Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at BFusion / BFLEX 2010 (Bloomington, Indiana) with: Ed Bartram

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 »