Search for double-quote in field 2

[hovercraft]

Greetings,
I'm trying to use the query builder to return a recordset of all records that may contain the quotation mark in the value.
I've tried instr(1,fieldname,chr34) but that hasn't worked.

Any suggestions?

Thanks,
Hovercraft.

 

[traingamer]

How about

Like "*""*"

i.e. simply use two double quotes.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[PHV]

A simpler way:

Like '*"*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[WyldeCarde]

If you did need to search for the " using instr, how would you go about that?

I doing some data "massaging" in VBA and have a need to find the position of the first set of quotes in a field

 

[PHV]

Simply search for Chr(34)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886