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:253717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
