The only way around it is to make a copy of the column in your original query, a upper(or lower) cased copy. Then do your compare against that.
In MX, we added ucase,lcase to the syntax, so you can do case insensitive matches. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: jon hall [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 20, 2002 1:42 PM > To: CF-Talk > Subject: query of queries LIKE case sensitivity > > > It seems that query of query's LIKE keyword in CF5 is case sensitive. > Is there a way around this? If not, does anyone know if this is fixed > in MX? > > -- > jon > mailto:[EMAIL PROTECTED] > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists