>>>I am not sure, I am not the one accessing the data. I have to assume it is the default settings.
>>>
>>>>
>>>>What are SET EXACT settings in OLE DB? And SET ANSI?
>>
>>I think in these settings (and also deleted settings) may be a problem.
>
>
>I think I found the primary cause. The .NET app was using a connection string with Collating Sequence=general. The index is MACHINE.
Exactly! Now when you wrote it I think that's what I meant <g>
Anyway, good you found the cause.
If it's not broken, fix it until it is.
My Blog