Hibernate Column Formula returning null
<p>In my hibernate mapping file, to obtain the FULL NAME of an employee, I have defined Column Formula as following.</p>

<pre><code>&lt;property name="empFirstName" column="emp_First_Name" type="string"
        not-null="false" lazy="false" /&gt;
    &lt;property name="empLastName" column="emp_Last_Name" type="string"
        not-null="false" lazy="false" /&gt;&lt;property name="fullName" formula="concat(emp_First_Name, ' ', emp_Last_Name)" /&gt;
</code></pre>

<p>But It returns <strong>null</strong> if any one of the property(either FIRST or LAST NAME) is <strong>null</strong>. How can I make it to return empty string for the null property..?</p>