Home Forums SQL Server 7,2000 Working with Oracle DTS to flat file for pickup by Oracle RE: DTS to flat file for pickup by Oracle
Kevin
SSCarpal Tunnel
Points: 4962
More actions
April 10, 2009 at 9:44 am
#975855
How about using the replace() function when selecting the data to export? Here is an example.
declare @test-2 varchar(8000)
select @test-2 = 'test
test
test'
select @test-2
select replace(replace(@Test, char(10), ''), char(13), ' - ')