UPDATE VS4TAR3 Set TAR3TitleName=replace(replace(TAR3TitleName,CHAR(10),''),CHAR(13),'')
,TAR3FirstName=replace(replace(TAR3FirstName,CHAR(10),''),CHAR(13),'')
,TAR3LastName=replace(replace(TAR3LastName,CHAR(10),''),CHAR(13),'')
GO

UPDATE VS4TAR3 Set TAR3TitleName2=replace(replace(TAR3TitleName2,CHAR(10),''),CHAR(13),'')
,TAR3FirstName2=replace(replace(TAR3FirstName2,CHAR(10),''),CHAR(13),'')
,TAR3LastName2=replace(replace(TAR3LastName2,CHAR(10),''),CHAR(13),'')
GO

UPDATE VS4TAR Set TARNName=replace(replace(TARNName,CHAR(10),''),CHAR(13),'')
,TARNName2=replace(replace(TARNName2,CHAR(10),''),CHAR(13),'')
GO