新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 删除

if exists ( select * from sys.objects where object_id = object_id(N'dbo.a_SignTxt') and type in (N'FN', N'if', N'TF', N'FS', N'FT') )
               drop     function                                       dbo.a_SignTxt
   go
   
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【函数】 dbo.a_SignTxt( 'xxx' )  提取符号

create function dbo.a_SignTxt
   (
       @Txt varchar(max) 
   )
   returns varchar(max) 
   as 
   begin
   ---------------------------------------------------------------------------------------------------------------------------------------------
      declare @Word nchar(1) ,@Cn varchar(max)  set @Cn = '' 
      
      while len(@Txt) > 0 
      begin 
         set @Word = LEFT( @Txt ,1 ) 
         
         if ( UNICODE( @Word ) BETWEEN    33 and    47 )  -- ! " # $ % & ' ( ) * + , - . /
         OR ( UNICODE( @Word ) BETWEEN    58 and    64 )  -- : ; < = > ? @
         OR ( UNICODE( @Word ) BETWEEN    91 and    96 )  -- [ \ ] ^ _ `
         OR ( UNICODE( @Word ) BETWEEN   123 and   126 )  -- { | } ~
         
         OR ( UNICODE( @Word ) BETWEEN 65281 and 65295 )  -- ！ ＂ ＃ ＄ ％ ＆ ＇ （ ） ＊ ＋ ， － ． ／
         OR ( UNICODE( @Word ) BETWEEN 65306 and 65312 )  -- ： ； ＜ ＝ ＞ ？ ＠
         OR ( UNICODE( @Word ) BETWEEN 65339 and 65344 )  --［ ＼ ］ ＾ ＿ ｀
         OR ( UNICODE( @Word ) BETWEEN 65371 and 65374 )  --｛ ｜ ｝ ～
         begin
            set @Cn = @Cn + @Word 
         end
            
         set @Txt = RIGHT( @Txt ,len(@Txt)-1 ) 
      end 
   ---------------------------------------------------------------------------------------------------------------------------------------------
      return @Cn
   end
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select dbo.a_SignTxt( '金额B(+本23位.币-3，)$as2#０．６ＢＣＤ' )   -- 提取符号：(+.-，)$#．

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go