Query to return number before letters

Hi all,



I would like to run a query which takes a code which contains a mixture of number and letter and returns all the number before the first letter. I was using the left function (=Left(([Codes],2)) but sometimes there is one number sometime two. The desired results are shown below;



7pol2try36 = 7

12cet9fre55 = 12

10yea3gtr77 = 10



Is this possible?



Thank you in advance.

Mark

Query to return number before letters