Hi
I'm running a 'LIKE' query against an Excel worksheet using ADO.NET and its proving to be case sensitive. I really want it to be case insensitive (which it should be according to all the info I can find) - does anyone have any ideas how I can achieve that?

My connect string is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyFile.xls;Extended Properties="Excel 8.0;HDR=YES;IMEX=1"

My query is: SELECT * FROM [Sheet1$] WHERE Chassis LIKE '%Foo%'

This does match Chassis entries of 'Foo', but not 'foo', 'FOO', etc.

Thanks in advance

Steve H