declare @str varchar(10)
set @str='asdf
sadf'
select @str
/*
asdf
sadf
*/
select replace(replace(@str,char(13),''), char(10), '')
/*
asdfsadf
*/
set @str='asdf
sadf'
select @str
/*
asdf
sadf
*/
select replace(replace(@str,char(13),''), char(10), '')
/*
asdfsadf
*/
SET paperNumber = REPLACE(paperNumber, CHAR(10) + CHAR(13), '')
不行啊
没有反应,还是有换行
insert @t select
'aa
cc
dd'
select * from @t
/*
col
--------------------
aa
cc
dd
(1 行受影响)
*/
update @t set col=REPLACE(col,'
','')
select * from @t
/*
col
--------------------
aaccdd(1 行受影响)
*/这样也行.
SET paperNumber = replace(REPLACE(paperNumber, CHAR(13), ''), CHAR(10), '')
SET paperNumber = replace(paperNumber , CHAR(10), '')
只替换char(10)就行了,谢谢各位指点