Write down the query to print first letter of a Name in Upper Case and all other letter in Lower Case.

YasminRadwan26

Save to bookmark

2022-05-13

470

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

YasminRadwan26

2022-05-13

need an explanation for this answer? contact us directly to get an explanation for this answer

Select UPPER(SUBSTRING(Firstname, 1,1))+ 
LOWER(SUBSTRING(Firstname, 2, Len(FirstName)-1))As Firstname from tblStudent

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)