u can try something like this...
Create Table #Temp
(
Name Nvarchar(40) Collate SQL_Latin1_General_CP1_CS_AS
)
Insert into #Temp
Values('asha'),('amma'),('bob'),('dad'),('Rear'),('Removed')
Select * From #Temp
Where Left(Name,1) =SubString(Name,Len(Name),1)
Select * From #Temp
Where Lower(Left(Name,1)) =Lower(SubString(Name,Len(Name),1))
Drop Table #Temp
Output:
Name
asha
amma
bob
dad
Name
asha
amma
bob
dad
Rear