ok i have this search i am working on except this colum that stors numbers like 1994-5668-273749-2 it is a varchar field in the db
in my query i can do this <CFIF #fReferAgencyNo# neq "">AND ReferAgencyNo = '#fReferAgencyNo#'</cfif> to get an exact match of the field but not <CFIF #fReferAgencyNo# neq "">AND ReferAgencyNo LIKE '%#fReferAgencyNo#%'</cfif> i am going nutty varchar is not a number.. this on a qoq of a stored proc. any ideas? i want to find a like or a in. not an exact match. thanks -paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Community/message.cfm/messageid:215747 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
