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

[Wilhelm T. <wi...@se...>]

SNLV works!

Thanks a lot Slavomir!


"Skopalik Slavomir" <sko...@hl...> wrote in message
news:01C...@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.
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>