楼上正解! 呵呵 补充一点点~declare @t1 varchar(50) set @t1='aaaaa bbbbbb' set @t1=replace(replace(@t1,char(13),''),char(10),'') print @t1
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO create function [dbo].[fn_removeChr13Chr10] ( @str varchar(max) ='helloworld', @IsRemoveChr13 bit =1, @IsRemoveChr10 bit =1 ) RETURNS varchar(max) as begin ---remove the key char(13)[return] in the string if @IsRemoveChr13=1 begin select @str=replace(@str,char(13),'') end---remove the key char(10)[换行] in the string if @IsRemoveChr10=1 begin select @str=replace(@str,char(10),'') endreturn @strend
有个
问题要问”,回车符号,'')
有个
问题要问”',回车符号,'')
char(10)——换行符
char(13)——回车符举个例子:
declare @t1 varchar(50)
set @t1='aaaaa'+char(13)+'bbbbbb'
print @t1
结果--------------------
aaaaa
bbbbbb
替换这个回车符即可:
declare @t1 varchar(50)
set @t1='aaaaa'+char(13)+'bbbbbb'
set @t1=replace(@t1,char(13),'')
print @t1结果------------------
aaaaabbbbbb
set @str='我
有个
问题要问'select replace(replace(@str, char(13), ''), char(10), '')
--result
我有个问题要问(1 row(s) affected)
呵呵
补充一点点~declare @t1 varchar(50)
set @t1='aaaaa
bbbbbb'
set @t1=replace(replace(@t1,char(13),''),char(10),'')
print @t1
set QUOTED_IDENTIFIER ON
GO
create function [dbo].[fn_removeChr13Chr10]
(
@str varchar(max) ='helloworld',
@IsRemoveChr13 bit =1,
@IsRemoveChr10 bit =1
)
RETURNS varchar(max)
as
begin ---remove the key char(13)[return] in the string
if @IsRemoveChr13=1
begin
select @str=replace(@str,char(13),'')
end---remove the key char(10)[换行] in the string
if @IsRemoveChr10=1
begin
select @str=replace(@str,char(10),'')
endreturn @strend