You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Select all documents where apollo:propertyCommander begins with "James".
Initial data:
document1: apollo:propertyCommander - Walter M. Schirra
document2: apollo:propertyCommander - Frank F. James, II
document3: apollo:propertyCommander - James A. Lovell, Jr.
document4: apollo:propertyCommander - Eugene A. James
SELECT * FROM cmis:document AS doc WHERE apollo:PropertyCommander LIKE 'James%'
Query result:
document3.