[Zope] odbc database adapter ... problem with "like"

[Pate, Clarence T]

Hello all!

Is there a problem when using "LIKE" with the ODBC database adapteor?  If you
notice, the error message says alike instead of like.  Is this normal?  Is
there a better way to perform a look up similar to this?

Error message in browser:

Z SQL Method at  /recert / director / sqlDirectorEmployeeByLastName 
Error, sql.error: ('37000', -3100, "
[Microsoft][ODBC Microsoft Access 97 Driver] 
Syntax error (missing operator) in query expression '(((NAME) alike
``Pate*``))'.") 

SQL used: (in ZSQL method)
select DIRECTOR_NAME, USERID, NAME, AUTHORIZED, TELECOMMUTER
from test_directors_names 
where (((NAME) like ""Pate*"")); 

Valid Access SQL:
SELECT nac_payroll_users_director_rc.USERID,
nac_payroll_users_director_rc.NAME,
nac_payroll_users_director_rc.DIRECTOR_NAME,
nac_payroll_users_director_rc.AUTHORIZED,
nac_payroll_users_director_rc.TELECOMMUTER
FROM nac_payroll_users_director_rc
WHERE (((nac_payroll_users_director_rc.NAME) like "Pate*"));

Clarence T. Pate