Thanks Dan.. just tried AND ReferAgencyNo LIKE <cfqueryparam value="%#fReferAgencyNo#%" cfsqltype="CF_SQL_VARCHAR" maxlength="17">
seems to work well CAST didnt seme to work. On 9/21/06, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote: > > Paul, > > >yeh i dont get it > >ReferAgencyNo = '91402' returns 1 search result > >if i use > >ReferAgencyNo like '%91%' i get an error below > > > >i have tried looking at ListFind, but thats not clicking.. > > How is your QoQ being generated? It sounds as if QoQ might be treating > your > varchar field as an integer value. Try using the CAST() function on your > column: > > > http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001271.htm#wp1182707 > > CAST(ReferAgencyNo as varchar) like '%91%' > > -Dan > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:253722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
