How about something like this: WHERE upper(PositionName) LIKE <cfqueryparam value="%#Ucase(TextToSearch)#%">
Matt Osbun Web Developer Health Systems, International -----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 26, 2005 2:05 PM To: CF-Talk Subject: Making CFQUERY Where Clause case insensitive Can someone tell me how to make this: WHERE PositionName LIKE '%#TextToSearch#%' Case insensitive, so it matches both upper and lower case instances? CF7, Win2K3 TIA, Tim ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212869 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
