• I think its a little bit late, but if helps someone .

    You can put some Replace in the same sentence like this

    declare @Table As Table (col nvarchar(50))

    INSERT into @table(col)

    Select 'dat1/dat2/dat3/dat4/1/2009'

    UNION ALL

    Select 'dat1/dat2/dat34/dat4/2/2009'

    UNION ALL

    Select 'dat1/dat2/dat/sd34/dat4/3/2009'

    UNION ALL

    Select 'ssf/sdf/sdf/sf/sf/sf/4/2009'

    UNION ALL

    Select 'ssf/sdf/sdf/sf/sf/sf/10/2009'

    UNION ALL

    Select 'ssf/sdf/sdf/sf/sdf/sf/sf/44444444/2009'

    UNION ALL

    Select 'ssf/sdf/sdf/sf//sdf sdf sf/sf/111/2009'

    UNION ALL

    Select 'ssf/sdf/sdf/sf/sf/sd sf sdf /1798/2009'

    select LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(RePLACE(REPLACE(REPLACE(REPLACE(

    col,'dat','') ,'sdf',''),'ssf',''),'2009',''),'/',''),'sf',''),'sd',''),'12344',''),'1234',''))) from @Table