How to split the single filed into 2 fields.

[Sivarapu250]

Dear Guys,

I have  one filed (No delimiter in that field). I need split that into two fields.  Like

Ex:  Filed1:

       S1ETM

        S1STM

        S2EMT

        S3EMT

        S4EMT

        S2END

etc..

I need output Like (LAST 3 RECODS)

Time:

       ETM

       STM

       EMT

        EMT

        EMT

        END

 Kindly help.

[derekjones]

right(Filed1,3) as Time