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.