hi experts,
A column on one of my reports contains NULL. I would prefer to have the query return blank for that column rather than NULL.
I tried COALESCE(MyColumn, '') but that returns 1900-01-01 00:00:00.000 Note that the column data type is datetime.
How can I do this in my Select statement?
Thanks very much.