Decode

SQL

SELECT DECODE(CSUSER01.FIRSTNAME, 'Sebastien', 'Seb', 'Benoit', 'Ben', CSUSER01.FIRSTNAME) AS FIRSTNAME01
  FROM CSUSER CSUSER01
 WHERE 1=1

XML query API

<query alias="testDecode" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
            <decode>
                <field path="firstName"/>
                <string>Sebastien</string>
                <string>Seb</string>
                <string>Benoit</string>
                <string>Ben</string>
                <field path="firstName"/>
            </decode>
         </projection>
    </projections>
</query>