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

Followers

Visitor No

click for free hit counter
Download a free hit counter here.