Check Number

F

Florence

Hi there:

I have a list with the data type - Text in the table. Some
contents may be 0002 or 123abc or abcde. How can I use
query to find out the records which all are numbers only
(like 0002)?

Thanks,
Florence
 
H

Heather

What about something like this?

Select x from myTable
where x = format(x,"0009");

You might have to look up the exact format style, but the
concept should work.
 
Top