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