Re: string is sometimes null ? - Mailing list pgsql-general

> If monthcurr or username are null, the above will be null.
> Anything || NULL => NULL.

AH! thanks sorted it now.  That is not the behaviour I would have
expected :)

Is there a concatination operator that will not do this? IE

if

var1 || var2 || var3

and var2 is null would result in just var1var3  ?

Many thanks for your help

--
-----
Graeme Hinchliffe (BSc)
Core Internet Systems Designer
Zen Internet (http://www.zen.co.uk/)

Direct: 0845 058 9074
Main  : 0845 058 9000
Fax   : 0845 058 9005