Separate numbers and characters from a string using SQL Server

Hi amol.londhe11...,

Refer the below query.

DECLARE @string VARCHAR(20),@Num VARCHAR(20),@str VARCHAR(20),@i AS INT
SET @string = 'AB78KH013Hj9';
SET @i = 0
SET @num = @string
SET @str = @string

WHILE @i <= len(@string)
BEGIN
    SET @str =  REPLACE(@str,SUBSTRING(@str,PATINDEX('%[^a-z]%',@str),1),'')
    SET @num =  REPLACE(@num,SUBSTRING(@num,PATINDEX('%[^0-9]%',@num),1),'')
    SET @i = @i + 1
END

SELECT @Num 
SELECT @str

Output

780139

ABKHHj