How to query text that start with a "*"

  • Thread starter Thread starter Dan
  • Start date Start date
D

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.
 
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.
 
Back
Top