On 27.06.2012, at 17:19, Furst, Carl wrote: > So here's the sql I use: > > select * from [nt:resource] where contains([jcr:data], 'include');
The full text index for binary properties is by default aggregated on the node itself, not on the jcr:data property. You address that with "*" and you need a selector (s in this case): select * from [nt:resource] as s where contains(s.*, 'include') (In the former sql1 you could simply to CONTAINS(., 'include') to adress the node itself). See my recent mail (about xpath, but same index is used): http://markmail.org/message/oc6uootrpxepso4d Cheers, Alex
