SQL Select statement for VB

[soundjam]

I am curious to know if there is someone out there that may be able to help me with select statements. I have a good idea of what I am doing. However this one I cannot figure out. Here it is!

I am opening a Form, Placing an ADO Data Control on the form. I set up the file I wish to access and set my OLE DB Provider to JET 3.51, Change cursor type to adOpenDymanic, set CommandType to adCommandText, and in the RecordSource I place this:
SELECT * FROM Inventory WHERE User like 'p*'

If i am looking for something with a "p" as in "public" in the database, the search does not find.

But, if I type "public" instead of "p*" the search will return the value that I wish

I would like to mention that when using the VisiData Manager the search works, but for some reason it won't when inside my application


Thank you to all who can help,
soundjam

[YoungBuck]

Try the Like statement:

SELECT * FROM Inventory WHERE User Like 'p*';

Good Luck

[zopailot]

See if Access or whatever you're using supports
this Like 'p%';

[soundjam]

I tried it and the 'p%' worked great.

Thank you for your replies
soundjam