extracting numbers from a memo field

[sthapa]

Hi all

I have a field on a database thats generally used to enter notes.
Within these are mobile phone numbers in no particular order(throughout the field)

Im not sure what the code is to enter in the query to display only mobile numbers from this notes field ?

Any help will be appreciated

Thanks

 

[TanisAgain]

I think you will find that this has been done before.

http://www.access-programmers.co.uk/forums/showthread.php?t=13536&highlight="extract+numbers+string"