I have a piece of SQL code which looks like this

select ...

,
case
when lac_value IS NULL then kv_tex.tex_text
+ if short_tex.tex_text is not null
then
nvl(' ' + unit_tex.tex_text, '')
else
''
fi
when lac_value IS NOT NULL then lac_value
+ if short_tex.tex_text is not null
then
nvl(' ' + unit_tex.tex_text, '')
else
''
fi
else
null
end criterium,
...

from etc.

This is all for the one column CRITERIUM in SQL QUERY !!!
How to make something similar in Firebird ?

Regards

Zoran




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