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

Bob Silverberg

Member since Dec 11, 2008

Recent Blog Comments By Bob Silverberg

  • SQL LIKE Clause Case Sensitive in ColdFusion MX Query-of-Query

    Posted on Apr 19, 2007 at 4:03 PM

    I just encountered this issue and found a solution that allows for case-insensitive searching with QofQ's. I know this is an old blog entry, but I thought I'd share it anyway. You can use a combination of LOWER() and LCase() to address this issue. In your example, your query would change to: SEL... read more »