Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at RIA Unleashed (Nov. 2010) with: Bob Silverberg and Carol Loffelmann and Vicky Ryder and Simon Free
Ben Nadel at RIA Unleashed (Nov. 2010) with: Bob Silverberg@elegant_chaos ) , Carol Loffelmann ( @Mommy_md ) , Vicky Ryder@fuzie ) , and Simon Free@simonfree )

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 »