Using a comma as criteria in a query

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a table which includes an field that sometimes has multiple
email addresses separated by a comma.

I need to select these from the database and expected to use the comma
as a criteria. An error message has advised to include the text in
quotes but that did not work either.

I expected to use *,*, I have changed to *","* which also fails.

How is it possible?

Many thanks,

Robin Chapple
 
Back
Top