Strip 1st & last character in string

[action]

I have customer ID that is has an M appended to the beginning and an X appended to the end as it is imported into another database. I now wish to create queries that pulls the data the other way and strip the M & X but not sure how. What can I use with in a query to ignore the M & X. Note the cusomer ID may vary in length. ie M12345X or M6557X.

As I have very limited VBA I want to do this with in a Query.

Thanks