Concatenate

SQL

SELECT ((CSUSER01.FIRSTNAME || ' ') || CSUSER01.LASTNAME) AS FIRSTNAME01
FROM CSUSER CSUSER01

XML query API

<query alias="testConcatenate" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection projectedField="firstName">
             <concatenate>
                 <concatenate>
                     <field path="firstName"/>
                     <string> </string>
                 </concatenate>
                 <field path="lastName"/>
             </concatenate>
        </projection>
    </projections>
</query>