List of all functions supported by CQ5 in SQL2 queries

[LinearGradient]

Hi,

Where can I get the list of all functions that CQ5 supports in SQL2 queries? In particular, is UPPER (to convert a string to upper case) supporter?

If not, how can a case insensitive equality condition be written?

Thanks.

[LinearGradient]

Looks like UPPER/LOWER are actually supported, but only on the left hand sand of a where condition equality.

[smacdonald2008 · Accepted solution]

Here is a good link for JCR SQL2:

http://www.day.com/specs/jcr/2.0/6_Query.html