Hi,

can anybody please expalin why I can't use the "COALESCE" function in
firebird.

I am trying to accomplish the following statement in a stored procedure.

select COALESCE(tbltest.id,0) from tbltest
where
tbltest.first_name='doppy'
and
tbltest.last_name='draws'

cheers

martin.

=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server


[Non-text portions of this message have been removed]