Little tiny squares

Hi just imported a bunch of fields from a text file and now have a bunch of little squares iat the end of each field, I assume that they are linebreaks or carriage returns, what is the easiest way to get rid of these?
D--You can use the replace command.

Eg.

declare @.string varchar(100)
set @.string='ABD'

select replace(@.string,'D','C')

Play around with it and you know how to use it for your problem.|||Originally posted by Patrick Chua
You can use the replace command.

Eg.

declare @.string varchar(100)
set @.string='ABD'

select replace(@.string,'D','C')

Play around with it and you know how to use it for your problem.

You should use it in an Update statement:

UPDATE <TableName> Set <FieldName> =
replace(<FieldName>, CHAR(x), '')

x is the ASCII code to identify your quares; try 10 (= CR), or 13 (= LF)|||worked like a charm thanks char(13) was itsql