Search comma delimited field

Y

ys

In Field1 of Table1 I have values such as:
A
B
C
A,B
B,C
A,B,C
I need to run a query that will give me records where
Field1 contains records with the multiple values such as
A,B or B,C or A,B,C. I don't know how to write the WHERE
clause. The multiples are always comma delimited. Help is
appreciated
 
V

Van T. Dinh

SELECT *
FROM [YourTable]
WHERE [Field1] Like "*,*"

OTOH, Field values that contain lists of data items violate the First Normal
Form which all databases should adhere to. Suggest you think seriously
before using this Table Structure.

Check out Relational Database Design Theory and Database Normalisation
technique.
 
Top