Jorrit

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 »