Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Query with multiple name varations

I work in a hospital, and we name the computers based on department/floor, my question is (and I apologize in advance, but I just can't figure this out) I have several floors/departments that have multiple naming conventions, for example: KR3, WOWKR3 and KU3. I'd like to create a query of floors/departments but I haven't been able to figure out how to manage the multiple naming convention.

Thanks!

0

Comments

2 comments
Date Votes
  • If I understand your request correctly, I think this will do what you're looking for:

    enter image description here

    0
  • That's not it, I forget to say that there was site names in front of the KR3/KU3/etc.. But thanks! I believe I have it figured out..

    0