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