These questions (one, two, three) all identified how to return an empty string instead of NULL
for a single column:
SELECT ISNULL(ColA,'') AS ColA FROM Table1
However, I have a query that returns a whole bunch of columns that I'm too lazy to select individually (don't worry - this isn't a production query)
SELECT * FROM Table1
Is there a way to return an empty string for all columns returned by the wildcard operator?
For Example, the following naive attempt won't work:
SELECT ISNull(*,'') FROM Table1