Community Member Profile

Rajendra prasad Panchati

Member since Dec 18, 2009

Recent Blog Comments By Rajendra prasad Panchati

SQL Server Text Matching Is Case INSENSITIVE

Posted on Dec 18, 2009 at 1:40 AM

Regarding above post, You can get the Collation Value from the properties of your database on which you are currently working.. Your Database-->Properties-->General(Under Maintenance).... read more »
SQL Server Text Matching Is Case INSENSITIVE

Posted on Dec 18, 2009 at 1:34 AM

Hi, COLLATE is the Keyword which help you to compare case sensitivity. Syntax: COLLATE (Collation Value) EX: COLLATE SQL_Latin1_General_CP1_CS_AS you should keep this part between the comparision statement EX: SELECT * FROM USERS WHERE USER_NAME COLLATE SQL_Latin1_... read more »