DB2 coalesce function for replacing null date

Db2 SQL Cookbook coalesce db2 The keywords VALUE and COALESCE can only be used in a join expression DB2) This will result in the generation of an SQL SELECT statement with an coalesce bigquery Solved: my query is as below select _ID, _ID, coalesce as REDUNDANT_STOCK_ID from STOCK_ARRIVAL SA

coalesce synonyms 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