Case (Switch by criterion)

SQL

SELECT CASE
         WHEN (CSUSER01.ANONYMOUS=1) THEN
          'Anonymous candidate'
         WHEN (CSUSER01.ANONYMOUS=0) THEN
          'Non anonymous candidate'
         ELSE
          'Unknown candidate'
       END AS firstName01
  FROM CSUSER CSUSER01

XML query API

<projection projectedField="firstName">
    <switchByCriterion>
        <cases>
            <case>
                <isTrue>
                    <field path="anonymous"/>
                </isTrue>
                <string>Anonymous candidate</string>
            </case>
            <case>
                <isFalse>
                    <field path="anonymous"/>
                </isFalse>
                <string>Non anonymous candidate</string>
            </case>
        </cases>
        <defaultValue>
            <string>Unknown candidate</string>
        </defaultValue>
    </switchByCriterion>
</projection>