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.