20081225 SQL Server裡的enter

SQL Server裡的enter
可以用這個把他replace掉


use replace and replace char(10) and char(13) with ''
sample sql:

declare @test varchar(255)
select @test = 'test 1234
2322'
select @test , charindex(char(10),@test), charindex(char(13),@test)
select @test = replace(replace(@test,char(10),''),char(13),'')
select @test , charindex(char(10),@test), charindex(char(13),@test)