Currently WHERE conditions are case sensitive when querying the Luminate Online web services.

For example, SELECT * FROM Constituent WHERE PrimaryEmail = 'john.smith@test.com' will not return any results if the value in Luminate Online is set to 'John.Smith@test.com'.

It would be useful to have LOWER() and/or UPPER() options so that matching can be performed when casing does not match.

For example, SELECT * FROM Constituent WHERE LOWER(PrimaryEmail) = 'john.smith@test.com' would return a result if the value in Luminate Online is set to 'John.Smith@test.com'.