Show only students whose first letter of the name does not begins between A to M, show the Gender column and change the value to Female.

Question

Q8
Pangalan Kasarian
Stephanie N. Female
Tian En Female
Xi Xi Female

Answer 1

select FirstName, LastName, Gender from dbo.Students
where FirstName like '[^A-M]%'

update dbo.Students set Gender = 'Female' where Gender IS NULL

Answer 2

Hi，@ANGELO REYES
Welcome to Microsoft T-SQL Q&A Forum!

Please check this：

Create table #Student  
 (  
 firstname varchar(10),  
 lastname varchar(10),  
 gender Varchar (10) check (gender in ('Female','Male'))  
 )  
 insert into #Student values  
('Pangalan','Kasarian','Male'),  
('Stephanie','N.','Male'),  
('Tian',' En' ,'Male'),  
('Xi',' Xi' ,'Male'),  
('HXw','ER','Male'),  
('APR','MKK','Female'),  
('EXw','ER','Male'),  
('GPR','MKK','Female')  
update #Student set gender='Female' Where firstname not between 'A%' and 'M%'  
select * from #Student  
Where firstname not between 'A%' and 'M%'  

Here is the raw data：

After you perform the update operation, there are only 4 rows of data left：

Best regards,
Bert Zhou

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.