Re: concat returns null

<p> Hello abyss,<p>Check out the built-in function COALESCE which will do your special-casing for you<p><br
/><p>Tuesday,December 18, 2007, 3:16:31 AM, you wrote:<p><br /><div><table border="0" cellpadding="1"
cellspacing="2"><trvalign="top"><td style="background-color: #0000ff;" width="13"><p><span
class="rvts6">></span></td><tdstyle="background-color: #ffffff;" width="1142"><p><span class="rvts7">I don't know if
it'sbug or feature but </span><p><span class="rvts7">select 'test' || null as result</span><p><span
class="rvts7">returnsnull, </span><p><span class="rvts7">so i need to case second parameter not to concat if it is
null...</span><p><br/></td></tr></table></div><p><br /><p><br /><p><br /><p><br /><p><span
class="rvts8">-- </span><p><spanclass="rvts8">Best regards,</span><p><span class="rvts8"> Andrew                      
    </span><a class="rvts9" href="mailto:drlaz@attglobal.net">mailto:drlaz@attglobal.net</a>