Jorrit
Member since Dec 11, 2008
- Profile: /members/616-jorrit.htm
- URL: http://www.jea.nl
- Comments: 1
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 »