Searching for an Asterisk in a query

K

Ken Pinard

Hello,
I am attempting to locate records that have an account name that starts
with and asterisk.

For example

** do not use **

But, I just don't remember how to search for a wild card. I should know,
but, brain dead today.

Please help

Thank you in advance,

Ken Pinard
 
K

Ken Pinard

Thank you, that worked. Well it works in Jet.

I just realized the procedure uses ADO. Do you know to do this in ADO?

Thank you again, I appreciate the help.

Ken

Tom Ellison said:
Dear Ken:

LIKE [*]*

Tom Ellison


Ken Pinard said:
Hello,
I am attempting to locate records that have an account name that
starts with and asterisk.

For example

** do not use **

But, I just don't remember how to search for a wild card. I should know,
but, brain dead today.

Please help

Thank you in advance,

Ken Pinard
Click to expand...
Click to expand...
 
D

Douglas J. Steele

Since * isn't a wildcard in ADO (the wildcard is %), you should be able to
use LIKE "*%"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Ken Pinard said:
Thank you, that worked. Well it works in Jet.

I just realized the procedure uses ADO. Do you know to do this in ADO?

Thank you again, I appreciate the help.

Ken

Tom Ellison said:
Dear Ken:

LIKE [*]*

Tom Ellison


Ken Pinard said:
Hello,
I am attempting to locate records that have an account name that
starts with and asterisk.

For example

** do not use **

But, I just don't remember how to search for a wild card. I should know,
but, brain dead today.

Please help

Thank you in advance,

Ken Pinard
Click to expand...
Click to expand...
Click to expand...
 
K

Ken Pinard

Thank you, Sometimes the obvious is not so easy to see :)

Thank you very much,

Ken

Douglas J. Steele said:
Since * isn't a wildcard in ADO (the wildcard is %), you should be able to
use LIKE "*%"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Ken Pinard said:
Thank you, that worked. Well it works in Jet.

I just realized the procedure uses ADO. Do you know to do this in ADO?

Thank you again, I appreciate the help.

Ken

Tom Ellison said:
Dear Ken:

LIKE [*]*

Tom Ellison


Hello,
I am attempting to locate records that have an account name that
starts with and asterisk.

For example

** do not use **

But, I just don't remember how to search for a wild card. I should
know, but, brain dead today.

Please help

Thank you in advance,

Ken Pinard
Click to expand...
Click to expand...
Click to expand...
 
Top