Finding BAC-5, BAC-8 And BAC-12???

[Nate74]

Greetings all,
It's been a while since I've had to turn to you for help. I'm usually able to find what I need in searching through previous posts, but no luck this time around.

I am trying to write a query criteria that will return

BAC-5, BAC-8 And BAC-12

I can get the -5 and -8 with:

Like "BAC-[58]"

But I can't figure out how to get the -12...

The actual part numbers are quite a bit longer and there are hundreds where I only need specific dash numbers returned.

I'm sure this one will be simple, I just couldn't seem to figure out how to search for it.

Thanks in advance!

 

[Uncle Gizmo]

I would suggest you separate this: BAC-12 into two fields:

identifyer >>>>> number
BAC - >>>>>>>>> 12

then all you need do is search on the number field.

 

[Nate74]

I would suggest you separate this: BAC-12 into two fields:

identifyer >>>>> number
BAC - >>>>>>>>> 12

then all you need do is search on the number field.

Thank you. I think you may put me over the edge on this one. I've encountered a dozen or so projects where naturalizing the data would be useful. Our part numbering structure really does not do well when queried...

Thanks for the input.

 

[RoyVidar]

In operator?

...IN ("BAC-5", "BAC-8", "BAC-12")

or
myField Like "BAC-[58]" OR myField ="BAC-12"