Hi all

I need some help please

I am trying to remove the pragraph marks ^p in a text field called
- advert.DescriptionDetails
when creating an export to a csv file from SQL Server using DTS driven from a
query

I have successfully used RTRIM to remove trailing spaces - but also want to
remove the embedded

The SQL is as follows - (abridged)~

SELECT advert.AdvertID AS VehicleID, RTRIM(advert.DescriptionDetails) AS
Description,
advert.SellingPrice AS Price, RTRIM(owner.County) AS
County, RTRIM(owner.Postcode) etc.......

FROM removed

WHERE removed
GO

Hope this is not off topic - the web site using this database was made with
Dreamweaver....

Best reagrds

Mark