
update dindansp set [no]=replace([no],'|',','),[no2]=replace([no2],'|',',')
update dindan set [delphotos]=replace([delphotos],'|',';'),[delphotos2]=replace([delphotos2],'|',';')

select no,no2 from dindansp 
select delphotos,delphotos2 from dindan