-
July 12th, 2009, 11:52 AM
#1
Case sensitivity with ADO.NET and Excel
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|