Hi ALZ

i did what u said but it did affect any row it shows

0 affected rows

my old column is (col1 nvarchar(50) null)

my new column is (newcol bigint null)

but u taken old column (col1 nvarchar(50) not null)

thanks for help

murali