ADO SQL wildcard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Campau - 18 Jun 2004 15:18 GMT

What is wrong with this querry:
I am doing something wrong with the wildcard.

I am writing in VB.Net to querry an Access database

SELECT ID, Doc_Title, Doc_Date, Doc_Keywords, Misc_Info, Doc_Location FROM
Documents WHERE (Doc_Title = 'PB*')

Thanks in advance

Reply to this Message

Alex Dybenko - 18 Jun 2004 15:46 GMT

Try:

Doc_Title LIKE 'PB*'

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> What is wrong with this querry:
> I am doing something wrong with the wildcard.
[quoted text clipped - 5 lines]
>
> Thanks in advance

Reply to this Message

Douglas J. Steele - 18 Jun 2004 15:58 GMT

The wild card for ADO is %, not * (and _, not ?). As well, Alex is correct
that you need to use the LIKE keyword rather than =

SELECT ID, Doc_Title, Doc_Date, Doc_Keywords, Misc_Info, Doc_Location FROM
Documents WHERE (Doc_Title LIKE 'PB%')

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> What is wrong with this querry:
> I am doing something wrong with the wildcard.
[quoted text clipped - 5 lines]
>
> Thanks in advance

Reply to this Message