Trouble executing SQL 2 query

[LinearGradient]

Hi,

I have slightly modified some SQL 2 queries from this page, but I cannot run them via CRX DE. Here's the query:

SELECT * FROM [cq:Page] WHERE PATH([cq:Page]) LIKE '/nodes/%'

The error message I am receiving is:

Query: SELECT * FROM [cq:Page] WHERE PATH([(*)cq:Page]) LIKE '/nodes/%'; expected: LENGTH, NAME, LOCALNAME, SCORE, LOWER, UPPER, or CAST

Any ideas why is this not working?

[Sham_HC · Accepted solution]

Look at [1] gives idea for reason and alternatives. 

[1]  http://jackrabbit.510166.n4.nabble.com/SQL2-via-davex-td3730048.html