Why does THIS SQL WORK?:
 objCommand.CommandText = "SELECT Title, Director FROM AllMovies WHERE Director LIKE 'Quentin Tarantino' OR Director LIKE 'Francis Coppola'"
But THIS SQL Does NOT work?: (NOTE The use of the "*" as a wildcard)
  objCommand.CommandText = "SELECT Title, Director FROM AllMovies
WHERE Director LIKE 'Quentin*' OR Director LIKE 'Francis*'"
  objCommand.CommandType = adCmdText

I am hitting against an ACCESS Database


Cmarek

__________________
Cmarek

It depends a bit what you use to connect to Access. I believe in an Access query directly, this will work.

If you're accessing the database through ADO, use the % symbol instead of the * as the wild card character.

Cheers,

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