Home Forums SQL Server 2005 Administering Replace the Null values RE: Replace the Null values

  • September 17, 2010 at 1:37 am

    #1222777

    See declare @t table ( id int )

    insert into @t

    select 1

    union

    select 2

    union

    select null

    select *, isnull(id, '') as new from @t

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)