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