RE: [Firebird-test] String concatenation......

[Skopalik S. <sko...@hl...>]

See SNLV UDF function.

Use like this:
'asasd'||SNVL(SurName,'')

	SLavek

> I have this problem with string concatenation:
> 
> SELECT FIRST_NAME||LAST_NAME FROM CUSTOMERS
> 
> returns NULL when any of the fields has a NULL value.
>