Filtering using IsNumeric and Left functions

[Kevin Johnston]

This should be easy - but I'm getting nowhere.



I have a text field called ISBN in a table. I want to query on the table, listing only those records in which the ISBN number starts out with a numeric digit. I thought that would be achievable with the following criteria in the ISBN column:

IsNumeric(Left([ISBN],1))

but the query comes back with NOTHING.

If I take the opposite tack to list just ISBN'S starting alpha -

Not IsNumeric(Left([ISBN],1))

I get back EVERYTHING (both alpha and numeric-beginning ISBN's).

What am I doing wrong?

Thanks!

[pbaldy]

I just tested this and it worked as expected:

WHERE IsNumeric(Left(PuStreet, 1))

Are you sure your field doesn't have a leading space or something?

[Datagopherdan]

Have you tried making a separate field as an alias such as NumericEval:IsNumeric(Left([ISBN],1)) and then in the criteria for that field have -1. That should only show the ISBNs that start with a numeric value.

Dan
Access Development

[Datagopherdan]

Have you tried making a separate field as an alias such as NumericEval:IsNumeric(Left([ISBN],1)) and then in the criteria for that field have -1. That should only show the ISBNs that start with a numeric value.

Dan
Access Development

This should be easy - but I'm getting nowhere.

I have a text field called ISBN in a table. I want to query on the table, listing only those records in which the ISBN number starts out with a numeric digit. I thought that would be achievable with the following criteria in the ISBN column:

IsNumeric(Left([ISBN],1))

but the query comes back with NOTHING.

If I take the opposite tack to list just ISBN'S starting alpha -

Not IsNumeric(Left([ISBN],1))

I get back EVERYTHING (both alpha and numeric-beginning ISBN's).

What am I doing wrong?

Thanks!

[Kevin Johnston]

Paul,

No, I don't have any leading zeroes.

Dan,

Your solution worked just fine! And if I substitute in NumericEval:Not IsNumeric(Left([ISBN],1)), it returns just the alpha-beginning numbers.

Any idea why the approach I was first taking didn't work? Not that it really matters since I have a working solution now.

Thanks!