Well, the ids are always 8 chars long so the commas arent really neccessary. I switched the fieldnames for easier readability and the data structure is fixed.
However it just doesnt seem to work. I wonder if the var char fieldlength has anything to do with it. . . Any other thoughts? DRE On 6/28/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210836 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
