How come, now this is a kicker, "...WHERE value LIKE '*';" -- just won't work? Has it gone completly mad? I just don't get it.

Hook your database to a ODBC SOURCE, won't allow that vital SQL Command, filter or (what ever pretty name we wanna call it), won't work.

Here is the strangest problem.

Setup a ADODB object, connection and what have you. To a DSN source kinda like the following
"DSN=MyDB;uid=admin;pwd=;database=DB"

Of course its registered with ODBC Data Sources through control panel.

then comes the big crunch.

"SELECT * FROM Jobs WHERE JobName LIKE 'D*';" or even * by itself.
No records get returned?

Anyone know how to solve this problem, or give a clue to aleast what the problem is caused by?

I think that you should be using '%' instead of '*'. '%' is the SQL wild card for one or more characters. _ (underscore) is the wild card for a single character.

So your SQL statement should be

...WHERE value LIKE '%'

That is amazing! I'm sure I tried that, out of despration, all the charactors on the keyboard. I just tried it and it works!

Thanks!!!!!!!