What is the escape char for *?

[TroyMcClure]

I want to find all records in a table where a certain field contains the asterisk character anywhere in the field. I've tried
Like "*" & Chr(42) & "*", but this just returns all records.

I'm thinking there must be an escape char, but I've tried some standard ones (/,\,[], etc), and none seem to work.
--T

 

[Golom]

How 'bout

WHERE Instr(fld, "*") > 0

?

 

[cmmrfrds]

Did you try putting in brackets.

yourfield like "*[*]*

 

[TroyMcClure]

Golom,cmmrfrds,
Thanks, both work. I thought I had tried the brackets surrounding as in cmmrfrds example, but I guess I just preceded the character with the bracket.
--T