Ayuda para separar string

[luchitox_desk]

Aqui dejo lo ue utilice finalmente...

Código:

DECLARE @sqlCursor CURSOR,
@varNumeroDesnormalizado VARCHAR(13) ,
@result VARCHAR(100)


SET @sqlCursor = CURSOR  FOR 
SELECT varNumeroDesnormalizado FROM TABLA

OPEN @sqlCursor
FETCH  NEXT  FROM  @sqlCursor
INTO @varNumeroDesnormalizado
      WHILE @@Fetch_Status = 0
      BEGIN 
      
      
            set @result=''
            select
                  @result=@result+case when number like '[0-9]' then number else '' end from 
                  (
                  select substring(@varNumeroDesnormalizado,number,1) as number from 
                  (
            select number from master..spt_values where type='p' and number between 1 and len(@varNumeroDesnormalizado)
                  ) as t
            ) as t
      
            PRINT @result
      
            FETCH  NEXT  FROM  @sqlCursor
            INTO @varNumeroDesnormalizado
      END
CLOSE  @sqlCursor
DEALLOCATE  @sqlCursor