Check Number

[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

 

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