Home Forums SQL Server 2005 SQL Server 2005 Integration Services Replace NULL with empty space. RE: Replace NULL with empty space.

  • September 16, 2010 at 9:47 pm

    #1222725

    I used below query

    USE dbname;

    GO

    select column1, column2, ISNULL(Column3, ' ') AS 'xxxx'

    FROM Table1;

    GO

    column3 (FK, int, null)