Using dbase, I want to find all records which have a phone that begins with a specific area code. I try
select name, phone
from contact1
where phone startswith '(918)'
(The same query works with crystal report.)
which produces...
Error, sql.error: ('37000', -3100, "[Microsoft][ODBC dBase Driver] Syntax error (missing operator) in query expression 'phone1 startswith '(918)''.")
I can use = as an operand but need to know how to use other odbc operands. 
Also, anyone know where a list of operands for dbase might be located on the internet.
Michael Guidry
michael.guidry@trigenttechnologies.com