Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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_General_CP1_CS_A = 'Your String'.... read more »