<CFIF searctext NEQ ""> <CFIF boolean is not 'null'> AND Textdata like '%#ReplaceNoCase(searctext,"+&","%' #boolean# Textdata like '%","ALL")#%' <CFELSE> AND Textdata like '%#searctext#%' </CFIF> </CFIF> If you place that in your query with a few alterations, you've got full boolean search... just have the user insert +& to indicate placement of a boolean and then let them select 'and' or 'or'. Tony Hicks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
