Trim

SQL

SELECT TRIM(CSUSER01.LASTNAME) AS LASTNAME01
  FROM CSUSER CSUSER01
 WHERE 1=1

XML query API

<query alias="testTrim" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
            <trim>
                <field path="lastName"/>
            </trim>
        </projection>
    </projections>
</query>