How to get a space when it is null?

Hello there,

One more question on sql output.

We have a column with values and nulls. The requirement from Treasury is to return the values or a space for the null. I used followings:

NVL(ColumnA, ' ') --- not '' but with a space

to_char (NVL(ColumnA, ' '))  -- I tried to force a space there

Both give me a space when it is null in sql output when I export the output to text file.

However, in our Oracle concurrent output, it gives me nothing when it is null, not a space when I save it to or copy/paste to a text file.