Breaking some numbers of of an alphanumeric string.

[weightinwildcat]

I have several years of database experience but am new to MySQL.

I have a column of data with text entries like the following:

W29N6432
N101W10362
S231

I need to break out all the numerical characters to the right of the rightmost letter. For instance, in the first string I would need to break out the characters 6432 to the right of the letter N.

I do not know of a formula for doing this in Excel, and I was wondering what suggestions people might have for doing this in MySQL.

Thank you for your help.

I am not sure

 

[ingresman]

it's a bit early for me to get a real andle on this ! but look at

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html

you miht be able to have 26 case statements (i.e. A..Z) and do a substr with the results therein.
There might be an easy with with the regex function in MYSQL. The manual has a lot of detail and I think you just need to being programmers cunning to the party !