hi there
I am trying to use the coalsce and replace function to extract thre fields into one (address) but am a little stuck.
This is my query but I keep getting an error when trying to pars it.

select
pt_serial,
coalesce(replace(pt_address_1, ',', ' ') + coalesce(replace(pt_address_2, ',', ' ') + coalesce(replace(pt_address_3, ',', ' ')) as pt_address
from plots

order by pt_serial

can anyone help please.

Thanks

Greg

Greg,

You haven't posted any data to test against and you haven't posted the error you're getting. My mind reading powers are just a bit weak today, so I might get this wrong, but...
you don't have enough parenthesis in the right spots AND COALESCE needs at least 2 arguments per instance.

--Jeff Moden