It does not like this piece of code

[eme126]

For some reason it does not like the percent sign:

oSQL = "SELECT*"
FROM TableInfo
WHERE Caption Like "' & strTarget & "%'"

oResults = oSQL.Execute

Any ideas...

 

[Karma]

For some reason it does not like the percent sign:

oSQL = "SELECT*"
FROM TableInfo
WHERE Caption Like "' & strTarget & "%'"

oResults = oSQL.Execute

Any ideas...

Try * instead.