Hi sushila

many thanks for the help

 I can get it to work with the code below but '^P' does not seem to work, not sure why.

RTRIM(REPLACE(advert.DescriptionDetails,char(10), '')) AS Description

Thanks again

Mark