Number extraction from a string

[Ed Reed]

Can someone help me with this?
 
I have a text field that sometimes contains a number preceded with the
letter N. So it might look like this
 
A test N60
 
or
 
N45 someother text
 
or 
 
This happened. N122, Then there was this.
 
I need to come up with a Select statement that can show me all the
instances where there is a N### value and return the number ### as a
separate field.
 
Anyone have a quick and easy solution?
 
Thanks