CREATE FUNCTION UFRemoveChar
(
@String nvarchar(20) )
RETURNS nvarchar(20)
AS
BEGIN
DECLARE @Point INTEGER
SELECT @Point = PATINDEX('%[^a-zA-Z0-9_]%', @String)
WHILE @Point > 0
BEGIN
SELECT @String = STUFF(@String, @Point, 1, '')
SELECT @Point = PATINDEX('%[^a-zA-Z0-9_]%', @String)
END
RETURN @String
END
(
@String nvarchar(20) )
RETURNS nvarchar(20)
AS
BEGIN
DECLARE @Point INTEGER
SELECT @Point = PATINDEX('%[^a-zA-Z0-9_]%', @String)
WHILE @Point > 0
BEGIN
SELECT @String = STUFF(@String, @Point, 1, '')
SELECT @Point = PATINDEX('%[^a-zA-Z0-9_]%', @String)
END
RETURN @String
END
No comments:
Post a Comment