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
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