Query for strings NOT containing a given character

[Marv Miller]

Is there a simple way to query for a string which does not contain a
given character? I have a database with a name field of the form
"lastname, firstname". As an error check, I would like to search for
entries which do not have a comma anywhere in the field.

 

[Duane Hookom]

SELECT [NameField]
FROM tblNames
WHERE Instr([NameField],",")=0;

 

[Van T. Dinh]

However, the correct Table Structure is to have TWO separate Fields, one for
LastName and one for FirstName. With 2 separate Fields, you can then
concatenate them whichever way you need.

 

[John Spencer (MVP)]

Criteria would be

NOT Like "*,*"

SELECT YourTable.TheFieldName
FROM YourTable
WHERE YourTable.TheFieldName NOT Like "*,*"