• Have a look at this

    declare @STR varchar(100)

    select @STR = '1230-544,15C5487,132DE78'

    ;With Breakdown as

    (

    Select

    SubString(@Str,1,1)[Chr],

    1[Idx]

    Union All

    Select

    SubString(@Str,Idx+1,1),

    Idx+1

    from Breakdown

    where (Idx+1)<=Len(@Str)

    )

    select chr from Breakdown where isnumeric(chr) = 1

    Edit:- This will return ',' and '-'. You need to filter them out.

    "Keep Trying"