NVL
SQL
SELECT NVL(CSUSER01.FIRSTNAME, 'Unknown') AS FIRSTNAME01
FROM CSUSER CSUSER01
WHERE 1=1
XML query API
<query alias="testReplaceNull" projectedClass="com.taleo.akirademo.entity.Candidate">
<projections>
<projection>
<replaceNull>
<field path="firstName"/>
<string>Unknown</string>
</replaceNull>
</projection>
</projections>
</query>