Hi to everyone

I have records like this M1I1A1,M1I2A2,M1I33A3,M2I1A4,M2I22A7 etc

I want to reterive records of type M1I[*] and not A*

I tried like this to reterive(Select * from table where field like M1I[0-100][!A*]) but i was unsuccessfully

please can anyone give me solution

thank u