16 Aug
1999
16 Aug
'99
4:24 p.m.
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