Jochem, Your method worked, I just had to add commas to the LIKE expression:
SELECT * FROM AllResults WHERE ',' & MyColumn & ',' LIKE '%,#idnumber#,%' Thanks very much! Dave -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 4:35 PM To: CF-Talk Subject: Re: SQL help (updated) [EMAIL PROTECTED] wrote: > Okay, I still need help, but I've resolve part of my problem. I'm able now > to have the list of ID numbers in one field by themselves. So, my new field > value (MyColumn) looks like this: > > '5,2,3,4,45,7' > > I still need a way using Query of Queries to extract only the records that > have the 'idnumber' in that list. I've tried: > > SELECT * > FROM AllResults > WHERE #idnumber# in MyColumn SELECT * FROM AllResults WHERE ',' & MyColumn & ',' LIKE '%#idnumber#%' Jochem ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:215399 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
