Check Number

  • Thread starter Thread starter Florence
  • Start date Start date
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
 
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.
 
Back
Top