isnummeric

  • Thread starter Thread starter Koen
  • Start date Start date
K

Koen

Hello,

I want to make a selection query from a table were there are nummeric and
alfanummeric records, is there a way to select only the alfanummeric
records...

Field1
test1
test2
7
test3
test3

I Just want this
test1
test2
test3
test3

Thanks,
Koen
 
I want to make a selection query from a table were there are nummeric and
alfanummeric records, is there a way to select only the alfanummeric
records...

Field1
test1
test2
7
test3
test3

I Just want this
test1
test2
test3
test3
Click to expand...

As selection criteria for "Field1", use:

Like "*[a-z]*"
 
Hello,

I want to make a selection query from a table were there are nummeric and
alfanummeric records, is there a way to select only the alfanummeric
records...

Field1
test1
test2
7
test3
test3

I Just want this
test1
test2
test3
test3

Thanks,
Koen
Click to expand...

As long as any number in the field is not the first character....
As criteria in this field, write:
 
Back
Top