Devart Forums

Hello

I have a IBQuery and Locate, my problem is being case sensitive.

My Query has many rows in UPPER CASE and others in Low Case words, the locate is case sensitive and I need to locate the words without this, how to do this?

Thanks
Alexandre

To use the Locate method in the case-insensitive mode, add the loCaseInsensitive constant to the Options parameter of this method:
See more details in our documentation:
http://www.devart.com/ibdac/docs/index. ... tions).htm

Thanks very much

You're right!! I had forgotten about this )

Feel free to contact us if you have any further questions.