i cant get the IN/CONTAINS to work on searching a numeric field. i can can get the result if the passed value is the exact Number. but if i want the subset of a number or any results with 1300 then i cant get it to work.
i have googled it, every way i can think <cfquery name="ClientList_Query" dbtype="query"> SELECT * FROM ClientList_Query1 WHERE 0 = 0 <!--- Search by ClientID ---> <cfif FORM.search IS NOT ""> AND ClientID IN (#FORM.search#) </cfif> ORDER BY #DefOrder# #URL.OrderByType# </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4