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.