Svein Erling Tysvaer wrote:

> to obtain what you want. Maybe you would also have to cast f1 and f2 in the
> last two selects to a char of the appropriate length - I do not know.
> Thinking about it, I think there is a NVL (or similar) function in a UDF
> library possibly making it possible for you to simply use
>
> select NVL(f1) || NVL(f2) from table
>
> I've never used this, so others will have to tell you how to use it.

There are NVL functions in fbudf. For strings (CHAR and VARCHAR) you can
use:

select sNVL(f1) || sNVL(f2) from table

However, this functions only exist for Windows, on other platforms you
may search the web for some other UDFs that do this.

Third option is to write the stored procedure which will do the select
and return exactly what you need.

--
Milan Babuskov
http://fbexport.sourceforge.net