How to make DPQuery case insensitive?

[AngusETM]

Hi all,

We're wondering whether anyone knows how to make DPQuery case insensitive. Is there any syntax or particular method to do this?

Here’s the query. It queries the name field using data from string sCurrentSelWild.

"SELECT '_original.._value' FROM '*.GIS.Name*' WHERE '_original.._value' LIKE \\""+sCurrentSelWild+"\\"";


Right now the query works, but it is case sensitive. We've tried using the typical "UPPER" and "LOWER" techniques but couldn't get this to work.


Regards,

Angus Heyworth

[kilianvp]

Hi,

No it's not possible. Queries always case sensitive. It's no real SQL