Is 'ODBC Text Driver' case sensitive?

[pavankiran]

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.

[Stear]

SELECT Path FROM Path_Table.txt WHERE LCASE(Path) LIKE '" & SampFolder & "%'"

SampFolder variable should be in lower case.

[WoF]

Well, how deep did you dig?
This thread is 10 years old!
Please do not revive old threads!
Do you think, after ten years the original poster will be happy that he finally got an answer?

[DataMiser]

It is amazing that so many people take the time to register here and make one post in answer to a question that is years old.

I doubt that case sensitivty was the problem anyway as I do not recall ever having a case sensitivity issue with any form of SQL. The wildcard maybe.

[WoF]

Right. I'm sure the wildcard character used within Access is "*", whereas when using SQL through ADO it is "%"
Also using the LIKE operator makes the comapre ignore the case.