MS SQL Server - Export Results To File without "NULL"

Question

I am using SQL Server Management Studio to export the results of my query to text. I would like to export the results without the character NULL being printed between delimiters.

For example, instead of:

,NULL, 

I would like to export:

,,

Thanks for your help

Answer 1

Just simply use

ISNULL(someColumn, '')

in our query. This will replace all NULL values with an empty string