I noticed that when I am using || to concatenate several fields, if one of them is null, the function returns null. Is there a way to return whatever values that are not null and ignor the null value?
select 'xyz-' || field1 || '=' || field2 '-' || field3 from tablename
if any of the fields is null, the returned results will be null. is there a function that would still return populated values?