isnummeric

[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

 

[Bruce M. Thompson]

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

As selection criteria for "Field1", use:

Like "*[a-z]*"

 

[fredg]

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

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