From Porcupine wiki

Developers: OQL SLICE function

Syntax:

Return a slice of an object. For instance:

select id, displayName from deep('/')
where slice(displayName, 0, 1) = 'R'

returns all the objects whose displayName starts with 'R'.