Multiple ANDs in SWQL

I have a report that works but have now been requested to exclude certain nodes from it.

The easiest approach that I can see, is that all the nodes bar one have DS0 in their name so my WHERE statement looks like:

WHERE
n.Interfaces.PhysicalInterface = 'Y'
and ClientPrefix = '123ABC'
AND NodeCaption LIKE '%DS0%'  


But I now need to add an extra one device that has a specific set of characters in its name. So how can I do the equivalent of:

ALSO INCLUDE NodeCaption LIKE '%XXX%'

Parents Reply Children
No Data