Splitting strings, same field

[davej311]

I have some text strings that I would like to split in a query but to be displayed in the same field, i.e.



String AAABBBCCC

To be displayed in the results as
1 AAA
2 BBB
3 CCC


Is this possible?

Thanks

[amrut]

You will need a UNION query
Something like
Select left([FieldName],3) as myField FROM [YourTable]
UNION
Select right([FieldName],3) as myField FROM [YourTable];