去除字符串中所有的符号(逗号除外)

set  ANSI_NULLS  ON
set  QUOTED_IDENTIFIER  ON
go
- -   = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
- -  Author:         < Author,, Name >
- -   Create   date :  < Create   Date , , >
- -  Description:     < Description, , >
- -   = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
ALTER   FUNCTION  [dbo].[deal_all_sign] (@s  varchar ( 200 ))
RETURNS   varchar ( 200 )
AS
BEGIN
     declare  @i  int
    while patindex( '%[^0-9,^a-z,^A-Z,^吖座]%' ,@s) > 0
     begin
       set  @i = patindex( '%[^0-9,^a-z,^A-Z,^吖座]%' ,@s)
       Set  @s = stuff(@s,@i, 1 , '' )
     end
return  @s
END