My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

Function to Parse AlphaNumeric Characters from String

Friday, 19 August 2011

CREATE FUNCTION dbo.UDF_ParseAlphaChars(@string VARCHAR(8000)
)
RETURNS VARCHAR(8000)AS
BEGIN
DECLARE 
@IncorrectCharLoc SMALLINTSET @IncorrectCharLoc = PATINDEX('%[^0-9A-Za-z]%', @string)WHILE @IncorrectCharLoc > 0BEGIN
SET 
@string = STUFF(@string, @IncorrectCharLoc, 1, '')SET @IncorrectCharLoc = PATINDEX('%[^0-9A-Za-z]%', @string)END
SET 
@string = @stringRETURN @stringENDGO

—-Test
SELECT dbo.UDF_ParseAlphaChars('ABC”_I+{D[]}4|:e;””5,<.F>/?6')GO

Result Set : ABCID4e5F6

No comments:

Post a Comment

 

Blogger news

Blogroll

Most Reading

8.6/10