I'm using the QUERY Builder in VB.NET Data Adapter Configuration
Wizard. I can retrieve records from my ACCESS database with
all my SQL statements until I insert a LIKE keyword in the
SQL statement. Then I get no records from my database. Are SQL
statements using LIKE not allowed?

Thomas A. Barta

Yeah, LIKE is supported, but it usually doesn't return records when you don't use a wild card as well.

Consider this colum value:

'I am a text value in a column'

Also consider a SELECT with a LIKE:

SELECT Bla Bla WHERE MyColumn LIKE 'text value'

This SELECT doesn't return a record, because the column does not contain 'text value' exactly.
However, if you use a wild card, things will change:

SELECT Bla Bla WHERE MyColumn LIKE '%text value%'

Now, a record will be returned, because 'text value' is somewhere in the text column.
Use

SELECT Bla Bla WHERE MyColumn LIKE 'text value%'

to select columns that start with 'text value'

and

SELECT Bla Bla WHERE MyColumn LIKE '%text value'

to select columns that end with that text.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.