> SELECT > id, > listofids > FROM > gv_locations > WHERE > ',' + listofids + ',' LIKE '%' + id + '%'
> But neither returns any records. > Any ideas? This would be the one I would use except, you need commas in your like statement... where ',' + listofids + ',' LIKE '%,' + id + ',%' the column names are horrid... assuming they're real column names... and the data structure is undesirable... But with or without the commas, I don't know why this query would produce zero records if the id is found in the listofids column -- I can't see any reason why it wouldn't return the appropriate records. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210833 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
