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