WHERE UPPER(PositionName) LIKE '%#UCASE(TextToSearch)#%' Or if you preffer:
WHERE LOWER(PositionName) LIKE '%#LCASE(TextToSearch)#%' UPPER() and LOWER() are the Oracle case functions, not exactly sure what the SQL Server equivilents are, but I'm sure they would be easy to find. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ....-----Original Message----- ....From: Claremont, Timothy [mailto:[EMAIL PROTECTED] ....Sent: Tuesday, July 26, 2005 12: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 ....********************************************************************** .... .... .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212868 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
