Wednesday, September 29, 2010

Select Case Sensitive String from Table in Sql Server

I have a Table in which record is following



Name               Age

nagendra           23

NAGENDRA   24



SELECT  Name,Age FROM Customers

WHERE  Name COLLATE Latin1_General_CS_AS = 'nagendra'



Output:

nagendra

No comments:

Post a Comment

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...