I have a column whos value is combination of two values:
(SELECT value FROM table where id = 'some_unique_id') || '/' || other_table.somecolumn
These two values can both have values, one may have a value, or none of them can have a value. If both have none value currently '/' is being displayed, but if both don't have a value I would like a blank to appear. If other_table.somecolumn has no value then it is being displayed as [firstvalue]/, but I would like ti without the / so it would just show the first value. Lastly if the first value has no value it is being displayed as /[secondvalue], but again I would like the / to be removed and only show the second value. I am unsure how to do this, I have tried to play around with the decode function, but can;t get it to work.
Aucun commentaire:
Enregistrer un commentaire