[EMAIL PROTECTED]>To:
[EMAIL PROTECTED]
cc:
06/24/2004 11:11 Fax
to:
AM Subject: Query Problem
with Lists
I have a table where one field is a
L PROTECTED]>
Sent: Thursday, June 24, 2004 10:11 AM
Subject: Query Problem with Lists
> I have a table where one field is a long list of numbers in
comma-delimited
> format.
>
> I need to do a query like:
>
> SELECT *
> FROM Table
> WHERE [number] IN list
>
> If
You probably shouldn't have setup your database structure like that.
You should always break out multiple values into a separate table, each
value being stored in one record, then "link" them through a common
record id. A one to many relation.
As far as the database is concerned, those aren't de
I have a table where one field is a long list of numbers in comma-delimited
format.
I need to do a query like:
SELECT *
FROMTable
WHERE [number] IN list
If I cut and paste the actual list in it works fine but when I use the
column-name containing the list it returns nothing. I've
