How do I pull the first 3 characters of a field

[Guest]

I have an item number example: TIMTIMUS63042RSC3
I need to pull the first three characters example: TIM
and make it my StkSec column. And the next 3 characters example: TIM
and make it my Brand column. And the next 2 characters example: US
and make it my CtryCd column.
Could someone assist me?

Thanks

 

[Guest]

Try this

Select Left(FieldName,3) as StkSec ,Mid(fieldName,4,3) As Brand ,
Mid(FieldName,7,2) As CtryCd From TableName

 

[Guest]

THANK YOU SO MUCH!!!!! You got it right on the money. : ) : )