Case (Switch by value)

SQL

SELECT CSUSER01.CSUSERNO AS CSUSERNO01,
       CASE CSUSER01.ANONYMOUS
         WHEN 1 THEN
          'Anonymous candidate'
         WHEN 0 THEN
          'Non anonymous candidate'
         ELSE
          'Unknonw candidate'
       END AS firstName01
  FROM CSUSER CSUSER01

XML query API

<projection projectedField="firstName">
    <switchByValue>
        <baseValue>
            <field path="anonymous"/>
        </baseValue>
        <cases>
            <case>
                <boolean>true</boolean>
                <string>Anonymous candidate</string>
            </case>
            <case>
                <boolean>false</boolean>
                <string>Non anonymous candidate</string>
            </case>
        </cases>
        <defaultValue>
            <string>Unknown candidate</string>
        </defaultValue>
    </switchByValue>
</projection>