Home Forums SQL Server 2008 T-SQL (SS2K8) replace RE: replace
jfdelette
SSC-Addicted
Points: 471
More actions
October 15, 2012 at 4:27 pm
#1549343
You can try this too :
update table
set c1 = convert(int,c1)+convert(int,c2)
where isnumeric(c1) = 1
and isnumeric(c2)= 1
Jeff.