Community Member Profile
Ashok
Member since Apr 28, 2010
- Profile: /members/5918-Ashok.htm
- Comments: 1
- Points: 10
Recent Blog Comments By Ashok
-
SQL Server Text Matching Is Case INSENSITIVE
Posted on Apr 28, 2010 at 6:41 AM
Ben,This has worked for me: SELECT * FROM Report_Lender_View_Field WHERE (CAST(name_of_col AS VARBINARY(10)) = CAST('searchstring' AS VARBINARY(10))) As developers we might not have access for the changing collate stuff. Cheers, Ashok... read more »
