Hi:

I'm having a problem with the MS ODBC Text Driver
I have a DSN which points to a CSV file.
Everything works ok until I try a WHERE clause involving LIKE.

SELECT * FROM customers.csv WHERE cust_name LIKE "some_value"

Error:
[State=37000] [Error=-3100] [Microsoft] [ODBC Text Driver]
Expresion cannot be used with the LIKE predicate. in query
expression 'cust_name alike 'some_value''.

I tried the SELECT with different ODBC drivers and DSN's and it works ok.
At first I thought WHERE clauses where not supported in ODBC Text Drivers.
But the following works ok (numeric comparison in the where clause):
SELECT * from customers.csv WHERE cust_id = 12345

I'd rather use some other driver but in this case I really need
to use the text driver.

Any ideas?

TIA