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


Member since Dec 11, 2008

Recent Blog Comments By Jorrit

  • SQL Server Text Matching Is Case INSENSITIVE

    Posted on May 24, 2007 at 8:08 AM

    You don't need to reininstall to do a case sensitve search. Here is an example: SELECT Col1, Col2, Col3 FROM MyTable WHERE Col3 COLLATE SQL_Latin1_General_CP1_CS_AS LIKE '%foo%' Here you set Col3 case sensitive. You can also use the "=" statement in stead of LIKE.... read more »