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