I want to replace all NULL value by nothing('') in an output query.
Note: I don't want to replace the NULL by nothing in the table.
SELECT row1, row2, row3 ISNULL(row1,'') AS row1 FROM table
Result: near "(": syntax error
Someone have an idea about the right syntax?
Thanks in advance,