I am getting empty space if I use below query
USE MYDB;
GO
select UserName, ISNULL(NULL, '') AS 'UserID'
FROM Tablename;
GO
I am getting 0 if I use below query
USE MYDB;
GO
select UserName, ISNULL(Userid, '') AS 'UserID'
FROM Tablename;
GO
--
But I need to replace NULL with empty space on where I have the NULL values.
In UserID column data all the rows are not NULL, only some of the rows. I need to replace them only with empty space.