• This will do what the OP requested, but highly unlikely it matches the real requirement, poor specification = poor solution:crying:.

    select SUBSTRING(Column1,1,2) as col1

    ,SUBSTRING(Column1,4,2) as col2

    ,SUBSTRING(Column1,7,2) as col2

    from tbaleOne

    I expect the splitter solution as suggested by BrainDonor will turn out to be the desired solution.