Re: Combining text fields

Doug,

> I just want to confirm that this is the correct behavior for the return
value
> when combining text fields together.  If one of the fields is NULL, then the
> return value of field1+field2 also becomes NULL.  If this is correct, is the
> proper way to get around this to use a default value of '' for such fields?

Use "COALESCE", e.g.:

SELECT street1 || COALESCE(street2, '') || COALESCE(street3, '')

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco