You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Select all documents where apollo:someProperty like 'ad%min%'.
Initial data:
document1: Title - node1, apollo:someProperty - ad%min master
document2: Title - node2, apollo:someProperty - admin operator
document3: Title - node2, apollo:someProperty - radmin
SELECT * FROM cmis:document AS doc WHERE apollo:someProperty LIKE 'ad%min%'
Query result:
document1.