Query-Split

I recommended use function for this.

CREATE FUNCTION ExtractInteger(@String VARCHAR(2000))
RETURNS VARCHAR(1000)
AS
BEGIN
        DECLARE @Count INT
        DECLARE @IntNumbers VARCHAR(1000)
        SET @Count = 0
        SET @IntNumbers = ''

        WHILE @Count <= LEN(@String)
        BEGIN
                IF SUBSTRING(@String,@Count,1) >= '0' AND SUBSTRING(@String,@Count,1) <= '9'
                BEGIN
                        SET @IntNumbers = @IntNumbers + SUBSTRING(@String,@Count,1)
                END
                        
                SET @Count = @Count + 1
        END
RETURN @IntNumbers
END
GO

Create table #test (Code varchar(200))

Insert into  #test (Code)
Select 'AXDE-123-YERT-RTEF' AS Code
UNION ALL
Select '648-WDSA-YUFG-BSFD' AS Code
UNION ALL
Select 'YUDF-AGAG-724-TERG' AS Code
UNION ALL
Select 'SHDF-UHDF-QWDF-345' AS Code

Select dbo.ExtractInteger(Code) from  #test 

drop table #test

Regards,

RAM