This SWQL query:
SELECT c.Name, c.Members.Name AS NodeName, CharIndex('-T1DR',c.Members.Name) as DR
FROM Orion.Container c
WHERE c.Members.MemberEntityType='Orion.Nodes'
...works fine. The column DR returns a positive, non-zero value for DR, a numeric showing the starting position of the specified substring.
This query:
SELECT c.Name, c.Members.Name AS NodeName, CharIndex('-T1DR',c.Members.Name) as DR
FROM Orion.Container c
WHERE c.Members.MemberEntityType='Orion.Nodes' AND c.Name='Customers' AND CharIndex('-T1DR',c.Members.Name)=0
...returns this...
Object reference not set to an instance of an object.
Basically I'm trying to use SWQL to create a list of nodes that are A) direct members of a particular group and 
do NOT end in "-T1DR" for the caption / node name.
