Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at BFusion / BFLEX 2009 (Bloomington, Indiana) with: Simon Free

Jorrit

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 »