Searching for an Asterisk in a query

[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

 

[Tom Ellison]

Dear Ken:

LIKE [*]*

Tom Ellison

 

[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

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

 

[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!)

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

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

 

[Ken Pinard]

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

Thank you very much,

Ken

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!)

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

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