Query specific digit in multiple digit number

[UBNSLICK]

Hello,

I would like to filter out numbers not having a specific digit in a certain location.

example - I want to see only the ones with (9) in the 7th digit location

2527100004
2527100006
2527109005
2527109007
2527200001
2527209005​

 

[Brianwarnock]

I think
Like "??????9*"

Should do it.

Brian

 

[MSAccessRookie]

Hello,

I would like to filter out numbers not having a specific digit in a certain location.

example - I want to see only the ones with (9) in the 7th digit location

2527100004
2527100006
2527109005
2527109007
2527200001​

2527209005​

While I am sure that there are fancy ways to do this with the numbers, the esaises and perhaps fastest way would be to conver the number to a string, and examine character #7.

mid(cStr(TargetNumber), 7, 1)

Of course, if TargetNumber is already a string, you can ignore the cStr.

Comment on BrianWarnock's reply:

His response will obviously be both easier and faster. I was unaware that those type of masks worked on numbers.

 

[UBNSLICK]

Brian,

That's it Thanks for the help.

I was close by using (help) but could not quite get it.

Have a great day!