AA2e72E wrote:

As far as I know, the JET 4.0 provider is case insensitive (not case
sensitive as you imply)

I am working with Excel and
...where Fields = 'Upper'
returns different rows than
.... where Fields = 'upper'

Maybe it depends on Excel, not on Jet 4.0.
However I don't know how to change it.


Upcase function does what I need.
I will see later how fast it is.

Thanks