RE: [ cf-dev ] CONTAINS

[Snake Hollywood]

Title: Message

from what you say it looks like u need   select * from table where URLID in (select IDLIST from table)   hth   Lord Snake -----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 18 May 2004 12:00 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CONTAINS Hi    I have a table with column containing a LIST of ID's   and I want to write a query that will return all records where the passed ID is in the list   something like   select stuff from table where URL.ID in (IDlist)   that obviously doesnt work   I am using access *run* any help would be muchly appriciated    Thanks    Matt   |\--------------------/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\--------------------/|