Check record to find non-number data type

  • Thread starter aspfun via AccessMonster.com
  • Start date
A

aspfun via AccessMonster.com

I need to run a query to find if claim number including any letter.
For example, 200910220001 is ok, but 20091022W001 is not.
There are about 10,000 claim numbers in a table. In order to convert all
claim number from text type to number type, data should be corrected first.
 
V

vanderghast

IsNumeric( string ) can be of some help, but note the letters E and D can
be part of a strictly numerical value: 1.0E3, 1.0D3 both represent 1000


? IsNumeric("123"), IsNumeric("WD40"), IsNumeric("42W22")
True False False



Vanderghast, Access MVP
 
P

Paolo

Hi aspfun,
use the isnumeric function to find the claim number that are completely
numeruc and those that aren't. It return true only if the argument is
completely numeric

HTH Paolo
 
Top