Community Member Profile
Bob Silverberg
Member since Dec 11, 2008
- Profile: /members/97-Bob-Silverberg.htm
- Comments: 1
- Points: 1
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 ch... read more »
