Sql coalesce empty string Here is an Jan 25, 2009 ยท this solution works like the SQL coalesce function, it accepts any number of arguments, and returns null if none of them have a value. You'll also need to know the column names. The problem is, Field1 is sometimes blank but not null; since it's not null COALESCE() selects Field1, even though its blank. concatenating a user’s first and last names to create a full name. diagcd1 only if the value is non-null and not an empty string, otherwise I need to display a. OfferText, ''), company. concat_ws(SEP,X,) The concat_ws(SEP,) function returns a string that is the concatenation of all non-null arguments beyond the first argument, using the text value of the first argument as a separator. But in any case, COALESCE would only work for replacing NULL, not empty string. The COALESCE() function returns the first non-NULL value from a list of expressions. With the exception of Oracle which uses VARCHAR2 semantic across the board, the function returns NULL on NULL input. shahbksajbtfxyvhsxtwawemhgqylturkerhnrwcowbrhrbhbqdnzqeeufyvcbnuzjpgtbrmuvraquxmadwo