Is 'ODBC Text Driver' case sensitive?


"SELECT Path From Path_Table.txt WHERE Path LIKE '" & SampFolder & "%'"

The above query returns no records if the case of 'Path' feild doesnot match with SampFolder variable.

I use a File DSN to read data from a text data file.

If Path="c:\Program Files\Common" and SampFolder="C:\Program Files" the above query returns EOF.

Any idea? how can i work around it?

Thanks,
Kiran.