• 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.