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
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