titan90

I am looking to use a query that will divide workstations into one of three automatic collections based upon the letter the computer name begins with. My goal is to use these collections for patching roll outs.

For example:
Collection 1 = A-H
Collection 2 = I-O
Collection 3 = P-Z

These need to be Workstations only - no servers.

With my basic SQL knowledge I am grabbing the computer name and doing > or = (letter) but am curious if there is a better way.

Thanks.

Titan90