GRChandrashekar
asked on
concatenate
MEMBERADDRESS.PHONENUMBER1
|| ','
|| MEMBERADDRESS.PHONENUMBER2
|| ','
|| MEMBERADDRESS.PHONENUMBER3
|| ','
|| MEMBERADDRESS.PHONENUMBER4
AS PH,
In this, if values are null the output comes as ,,,, or in between is any is null it comes like 1,,2
any way i can sort out this problem
|| ','
|| MEMBERADDRESS.PHONENUMBER2
|| ','
|| MEMBERADDRESS.PHONENUMBER3
|| ','
|| MEMBERADDRESS.PHONENUMBER4
AS PH,
In this, if values are null the output comes as ,,,, or in between is any is null it comes like 1,,2
any way i can sort out this problem
That, or just replace multiple ',,,' with one.
replace(replace(replace(ne w_str,',,, ,',','),', ,,',','), ',,','')
replace(replace(replace(ne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
MEMBERADDRESS.PHONENUMBER1
|| case when MEMBERADDRESS.PHONENUMBER1
...