>
> 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 ?
>

Hi, it's pretty much the same except:
Instead of nvl use coalesce.
String concatenation operator is ||.
Instead of if, use iif.

Unless I missed something, that's it. Try it and post back if you need further help.

Sasha