Good question, I've only ever used it with integers, if that doesn't work, try putting single quotes inside the double quotes
value="'%#Variables.searchString#%'" not sure what works, but it's an idea if it doesn't Ade -----Original Message----- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 09 September 2002 16:57 To: CF-Talk Subject: cfqueryparam and LIKE Do I need to do anything special to use the LIKE operator in SQL with CFQUERYPARAM, or is it as straightforward as I think? WHERE search_text like <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="%#Variables.searchString#%"> -- Al Everett Allied Office Products www.askallied.com mailto:[EMAIL PROTECTED] v: 973-594-3209 f: 973-594-3626 ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
