Funtion to get Alphabet Parts of the Alphanumeric String

Alter function GetLetters(@string NVARCHAR(50))

RETURNS VARCHAR(20)

AS

BEGIN

DECLARE @IncorrectCharLoc SMALLINT

SET @IncorrectCharLoc = PATINDEX('%[^A-Za-z]%', @string)

WHILE @IncorrectCharLoc > 0

BEGIN

SET @string = STUFF(@string, @IncorrectCharLoc, 1, '')

SET @IncorrectCharLoc = PATINDEX('%[^A-Za-z]%', @string)

END

SET @string = @string

RETURN @string



end

selectdbo.GetLetters('ABC_I+{D[4|:e;5,<.F>/?6')


output
ABCIDeF