get the number only

A

Amy

Hi there:

I want to capture the record which contains number only
from a column of a table. But the type of this column
is "Text" in the table. For example, the records in the
table can be abcdefg, abc, 12abc, 23456, 00002, 1,
kkkk ........etc. In these records, I only want to capture
23455, 00002, 1. How can I do by query?

Thanks,
Amy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top