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


Member since Apr 28, 2010

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 »