Invalid char in SQL in VB6 with Access97 ?

Hi all,

What's wrong with the next SQL-statement in VB6-code using ADO
to retrieve a recordset from an Access-database (97)

"SELECT ZAN_KNA1.KUNNR, ZAN_KNA1.NAME1, ZAN_KNA1.STRAS, ZAN_KNA1.PSTLZ, ZAN_KNA1.ORT01, ZAN_KNA1.LAND1, ZAN_KNA1.LOEVM From ZAN_KNA1 WHERE (((ZAN_KNA1.NAME1) Like " % " & [m_Name] & " % ") AND ((ZAN_KNA1.ORT01) Like " % " & [m_City] & " % ") AND ((ZAN_KNA1.LAND1) Like " % " & [m_Country] & " % "))"

m_Name etc. are variables with normal values.
% is the wildcard.

Help would be wonderful,

Greetings, Ger.

Sorry, but i got an error

Ïnvalid character for the % ????????

Ger.

And when I change the % in a *, then the syntax is OK, but when
i run the program i got an error TypeMismatch ?????


ohoh, i cannot sleep of it !

Ger