Hi,

You could use the REPLACE function to replace the carriage returns with a blank space...

SELECT REPLACE(REPLACE(FieldName,Char(13),''),Char(10),'') from TableName

The Char(10) and Char(13) should take care of the new line and carriage return values in the field...

If the field in question is of "text" type then you will have to use the UPDATETEXT function...