WIld card escape character

Tracy

Registered User.
Local time
Today, 03:51
Joined
Oct 19, 2001
Messages
71
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
 
The square brackets:-

Description Like "*[*]*"
 
Thanks!

Thanks for posting this!

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

Tim
 

Users who are viewing this thread

Back
Top Bottom