i am new bee let me try to provide actual requirement

Create table dbo.UpdateDef( SourceTableName VARCHAR(100),ColumnName VARCHAR(100),Status_fl CHAR(1))

go

insert into dbo.UpdateDef values ( 'dbo.Src','NAME','Y')

go

insert into dbo.UpdateDef values ( 'dbo.Src','ADDRESS','N')

go

insert into dbo.UpdateDef values ( 'dbo.Src','AGE','Y')

go

insert into dbo.UpdateDef values ( 'dbo.Src1','FName','Y')

go

insert into dbo.UpdateDef values ( 'dbo.Src2','LName','N')

go

insert into dbo.UpdateDef values ( 'dbo.Src2','SSN','Y')

go

insert into dbo.UpdateDef values ( 'dbo.Src','phone','Y')

go

i want to generate update statements as below based on information available in update def table

update Src a

set a.name = replace(a.name,'s','t')

,a.age = replace(a.name,'2','3')