Concatenate address fields in DB2 where fields can contain null

SQL Optimizer for DB2 ZOS 1 coalesce db2 Solved: my query is as below select _ID, _ID, coalesce as REDUNDANT_STOCK_ID from STOCK_ARRIVAL SA coalesce معنى but unable to use in DB2 Hi DCUnited, Using the coalesce () function is the correct approach From your post, it looks like your strings are

coalesce db2 Description COALESCE accepts a comma separated list of parameters and returns the first value that is not null in that list or null if all the arguments are