Popular Posts

Thursday, May 19, 2011

Remove Char from String

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

No comments:

Post a Comment