How to query text that start with a "*"

[Dan]

Hi


I want to query out records that have in a description
field a *. Basically the descriptions I want to pull out
are the ones that start with a * (ex: *1,2,3). So in
the criteria I tried Like "**" and Like "*/*", but
neither one worked. Is there a way I can tell it to give
me the ones that have a text that starts with *?

Thank you.

 

[Steve Schapel]

Dan,

Like "[*]*"

 

[John Spencer (MVP)]

When you need to search for a wild card character in a like clause, try
enclosing the character you are looking for in square brackets.

Where Description Like "[*]*"

That should find all Descriptions that start with an asterisk (*) and have zero
or more characters after the asterisk.

 

[ExcellentGent]

Try this:

Like "[*]*"

or

Left([fieldname], 1) = "*"