finding chr$(34)

[David44Coder]

Have searched but found no answer I could use.
How might I correct this to show only records where MyField has chr$(34) ?

Select * from table1 Where MyField Like "***"

Thanks

 

[June7]

Asterisk is Chr(42)

Like "*[*]*"

or

InStr(MyField, "*") > 0

Review https://support.microsoft.com/en-us/office/use-wildcards-in-queries-and-parameters-in-access-ec057a45-78b1-4d16-8c20-242cde582e0b#:~:text= Use wildcards in queries and parameters in,view. In... 4 See also. See More.

 

[arnelgp]

Chr$(34) is Double quote.

Select * from table1 Where Instr(1, MyField, Chr(34)) <> 0;

 

[David44Coder]

Many thanks, all locked in nicely.