How to search by a text field containing "?

[DMC]

I have a table that holds client registration info in a Access 2003 database.
Some of the client first names contain "", e.g., John"NE" or Mary "DEC" etc.
Does anyone know how I can search for those records that have "" in FirstName
field?
Thanks!

 

[KARL DEWEY]

A quote is ASCII character 34 so use this ---
Like "*" & Chr(34) & "*"

 

[Ofer Cohen]

Try

SELECT TableName.*
FROM TableName
WHERE TableName.FirstName Like "*""*"

 

[John W. Vinson]

I have a table that holds client registration info in a Access 2003 database.
Some of the client first names contain "", e.g., John"NE" or Mary "DEC" etc.
Does anyone know how I can search for those records that have "" in FirstName
field?
Thanks!

Use a criterion of

LIKE '*"*'

The ' delimiters will prevent trouble with " being confused with a delimiter
rather than a search term.

John W. Vinson [MVP]

 

[DMC]

Thanks Karl, Ofer and John!

I tested all of the three suggestions:
1. Like "*" & Chr(34) & "*"
2. Like "*""*"
3. LIKE '*"*'
1 and 3 return the same record set, which is exactly what I want;
2 returns only one record, which contains two consecutive quotes: ""

Cool! Thanks again!