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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Parameters 1
Delete duplicates with conditions 2
Query-matching data with multiple choices 5
search query 0
How do I show all characters before the letter A in a Query? 6
Query on two tables with matching null fields 4
Identifying single values in a field that stores muliple valuesseparated by a comma 10
Establish a Relationship Where Comma Delimited 4

Back
Top