i have an string like this format in my case i need to extract only the characters from string case

1)12AB
2)SD12
3)1WE4

output

1)AB
2)SD
3)WE

i need to extract only the characters i am using this expresion in the dervied column in SSIS package

SUBSTRING(MediaIDCode,1,2)

but this expresssion works for only this condition

1)12AB

i need to get an expressioin that works for all the conditions above

any help would be great

Thanks

Prince