[comp.sys.mac.apps] CL/1 Queries via Microsoft Excel

gclatworthy@pbs.org (08/23/90)

Has anyone used Microsoft Excel's new Data Access Macro to query
an SQL database via CL/1?  I'm trying to match on a text pattern, 
with no results.

I typed "like 'TEXT%'" into a criteria cell, hoping to match on
all entries starting with the first four letters.  Unfortunately, 
Excel added an "=" to the front of the string as it translated it
into the SQL query.

The pamphlet that comes with the macro refers only to numeric
operators, and I've exhausted all the variations I can think of in
the cell reference.

Thanks for your help in advance.