Wildcard in Query

[dt114]

I try to search some records in an Access database using my VB.net program. I use a "like" keyword with wildcard. For example, the records in Field1 in table TEST are:

aaa
abc

When I use
"Select [Field1] from TEST where [Field1] like '*b*'"
to search the 2nd record "abc", it gives me 0 search result. Using the same statement with wildcard is fine in Access and in old VB versions, but not in VB.net.

Does any one have idea about this?

 

[nigelrivett]

Only that you might be better off posting in the vb.net forum (or access).

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[r937]

i don't know .net (and never will) but perhaps try using a percent sign instead of the asterisk

see
A100219: SQL Wild Cards, ADO and Microsoft Access

http://www.devguru.com/features/knowledge_base/A100219.html

rudy

http://r937.com/

SQL Consulting