how to split a string using a variable number

[David Mountford]

I have a string that contains alfa & Numerics
I need to query the numeric part which could be anywhere within the string

 

[raskew via AccessMonster.com]

Hi - Take a look at this:
http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/39325/conver-text-to-number


Bob