Have Geek Brain

Can SSMS display white space as a character?

I am currently working on a dataset where I would like to return records where a specific field is NOT NULL. The dataset is the result of joining a table.

My result set is still returning records where the field I said not to return NULL appears to be empty. I would like to see what the true value is in these entries as they do not appear to be true NULLs.

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

0


a source to share


1 answer


Not directly.

You will need to change your request. Use substitution to turn spaces into something else?



REPLACE(MyCol, ' ', '#')
+1


a source






More articles:


All Articles