I have a column on which there are blanks spaces in a column instead of null.... I need to create a view on it where I replace all the blank spaces with NULL... I wrote a query like this but it is not working...Any suggestions??
WHEN X.column4= ' '
END AS COLUMN4a,