Unique first 5 of computer names

I’d like to find all of the unique values of the first 5 characters of the PC name of a group.

names of members of bes computer groups whose (name of it = "Workstations")

Its pretty simple… I’ll use bes computers as an example though

 unique values of firsts 5 of names of bes computers
2 Likes

ahh, it was the “firsts” part that was messing with me. I was just using “first” at first. :wink:

Thanks @AlanM

The plural relevance sometimes isn’t obvious :slight_smile: