I have a database that has an important field that is an alphanumeric field that is mixed as such:<br> AB123456<br> ABC123456<br> AB123456Z<br> A123456BCD<br><br>In other words, no pattern. Is there any way that I can capture the numbers only, and remove the alpha? Thanks. Laura<br> <p>Laura Velez<br><a href=mailto:lauravelez@home.com>lauravelez@home.com</a><br><a href= > </a><br>