Hi Torsten, Yes, I have seen the link and have tested the following queries as well but none worked. SELECT * FROM [nt:resource] as resource WHERE CONTAINS(resource.*, 'This') SELECT * FROM [nt:resource] as resource WHERE CONTAINS(resource.*, 'This*') SELECT * FROM [nt:resource] as resource WHERE CONTAINS(resource.*, '*This*') My other JCR-SQL2 queries work just fine until I add the CONTAINS clause. I don't see errors in the log file either. When I dump the result of the query without the CONTAINS clause, I am able to see the text being searched. Below is an example of the dumped data with some lines omitted to reduce size. [rt.jcr:configuration] ---> [] [rt.jcr:activity] ---> [] [rt.jcr:uuid] ---> [5183ee77-3aa9-497f-928a-4e61b2cac14c] <> [rt.jcr:baseVersion] ---> [ee23fbe3-ec5e-4b29-bed1-24fd5a0a78c1] [rt.jcr:isCheckedOut] ---> [true] [rt.jcr:primaryType] ---> [rt:RuleTariff] [rt.rt:EffectiveStartDate] ---> [20140101000000.000] <> [rt.jcr:versionHistory] ---> [ef428650-639e-4153-9c56-26c82b5fe26b] <> [file.jcr:createdBy] ---> [admin] [file.jcr:created] ---> [2013-06-12T13:36:36.746-07:00] [file.jcr:primaryType] ---> [nt:file] [resource.jcr:lastModifiedBy] ---> [admin] [resource.jcr:uuid] ---> [3cc13d9e-5f52-49b3-a85d-e626f691305d] [resource.jcr:data] ---> [ <> <>

This is the body.

<> ] [resource.jcr:encoding] ---> [UTF-8] [resource.jcr:mimeType] ---> [text/html] [resource.jcr:lastModified] ---> [2013-06-12T13:36:36.756-07:00] regards, Orlando -- View this message in context: http://jackrabbit.510166.n4.nabble.com/jackrabbit-2-6-0-Full-Text-Search-tp4658832p4658867.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.