MSSQL移除字符串两边的指定字符代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 MSSQL移除字符串两边的指定字符

作者:Dezai.CN / 发布于2011/12/30/ 548

<div>移除字符串左边的字符：</div>
<div>CREATE FUNCTION [dbo].[RemoveLeftChar]</div>
<div>(</div>
<div>  @Expression varchar(max),</div>
<div>  @char varchar(4)</div>
<div>)</div>
<div>RETURNS varchar(max)</div>
<div>AS</div>
<div>BEGIN</div>
<div>  WHILE LEN(@Expression)>0 AND CHARINDEX(@char,@Expression)=1</div>
<div>  BEGIN</div>
<div>    SET @Expression=SUBSTRING(@Expression,LEN(@char)+1,LEN(@Expression))</div>
<div>  END</div>
<div>  return @Expression</div>
<div>END</div>
<div>移除字符串右边的字符：</div>
<div>CREATE FUNCTION [dbo].[RemoveRightChar]</div>
<div>(</div>
<div>  @Expression varchar(max),</div>
<div>  @char varchar(4)</div>
<div>)</div>
<div>RETURNS varchar(max)</div>
<div>AS</div>
<div>BEGIN</div>
<div>  DECLARE @Len int</div>
<div>  SET @Len=LEN(@Expression)</div>
<div>  WHILE @Len>0 AND SUBSTRING(@Expression,@Len-len(@char)+1,@Len)=@char</div>
<div>  BEGIN</div>
<div>    SET @Expression=SUBSTRING(@Expression,1,@Len-LEN(@char))</div>
<div>    SET @Len=LEN(@Expression)</div>
<div>  END</div>
<div>  return @Expression</div>
<div>END</div>
<div>移除字符串左边的字符：</div>
<div>1、</div>
SELECT [dbo].[RemoveLeftChar]('|123|234|345|','|')</div>
<div>--输出结果</div>
<div>123|234|345|</div>
<div>2、</div>
SELECT [dbo].[RemoveLeftChar]('|||123|234|345|','|')</div>
<div>--输出结果</div>
<div>123|234|345|</div>
<div></div>
<div>移除字符串右边的字符：</div>
<div>1、</div>
SELECT [dbo].[RemoveRightChar]('|123|234|345|','|')</div>
<div>--输出结果</div>
<div>|123|234|345</div>
<div>2、</div>
SELECT [dbo].[RemoveRightChar]('|123|234|345|||','|')</div>
<div>--输出结果</div>
<div>|123|234|345</div>
<div></div>
<div>移除两边的字符(组合)</div>
SELECT [dbo].[RemoveLeftChar]([dbo].[RemoveRightChar]('|123|234|345|','|'),'|')</div>
<div>--输出结果</div>
<div>123|234|345</div>

试试其它关键字

　移除字符串　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)