Can SSMS display empty space as a character?

Question

Right now I'm working on a dataset where I would like to return records where a certain field is NOT NULL. The dataset is result of a table join.

My resulting set is still returning records where the field I told not to return NULL look empty. I'd like to see what the true value in these records are since they don't seem to be true NULL.

Is there a way to get Management Studio to show spaces as a character just so I can see what's in there if anything?

Answer 1

Not directly.

You'll have to modify the query. Use replace to turn spaces into something else?

REPLACE(MyCol, ' ', '#')