SQL? Replace carriage return

[Mbroad]

Hi i have a text data file which contains carriage returns (which we do not wnat within the data)--I am not sure if this is somethiong to be done in SQL or another platform. I need to read in this file and reaplce all carriage-returns with a space.
Any ideas?
Thanks

Government Coder Mark

 

[bborissov]

How you import this file in SQL Server?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[Mbroad]

I have not yet tried to import--I do not know if SQL Server will import without difficulties---I will attempt

Government Coder Mark

 

[SQLDenis]

declare @v varchar(50)

select @v ='1
2
3
4
5
'

select replace(@v, char(13) + char(10),' ')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/