WIld card escape character (1 Viewer)

[Tracy]

Hi,.

I am trying to use a criteria in a query as follows:

Description like "*"

I want to retrieve all records where the Description contains an asterisk, but at the moment (as expected) everything is returned, because asterisk is the wildcard.
There should be a charcter I can precede the aserisk with to make it retrieve what I need.

Any ideas.

Thanks
Tracy

 

[Jon K]

The square brackets:-

Description Like "*[*]*"

 

[tlucas]

Thanks!

Thanks for posting this!

Had a colleague with a similar question, and was able to help her out with this post.

Tim