|>Use % instead of the asterisk: |>where NAME like 'Pate%'

MS Access in it's infinite wisdom decided to go against the convention of using '%' as a wildcard and decided to use '*', so the SQL is correct for Access.

You are of course right concerning Access' use of >wildcards. But in ZSQL-Methods only the '%' gives me the expected results - >the '*' as wildcard will be ignored. I use Access 97 as database and >ODBC 4.00.

Thomas, Thanks! "%" as the wilcard did the job. Clarence T. Pate