Search comma delimited field

  • Thread starter Thread starter ys
  • Start date Start date
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
 
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.
 
Back
Top