SOLVED Having trouble creating query based collection

[rastogirachit]

I am trying to create a query based collection in SCCM for the hostnames which contains specific letter. I am able to do it one by one but is there anyway, I can create 1 collection by using the different specific letter. as an example, I am trying to create collection with hostname having -s, -w, -w1.

 

[Garth]

Use the like option in the query builder.

 

[rastogirachit]

I tried that. as I mentioned I am able to do it with 1 condition. is it possible to add multiple condition in like option. this is how it looks as of now.
select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.NetbiosName like "%S%"

So, I am wondering, if i am able to add more letter after S in any way so it detects those letters as well.

 

[Garth]

Sure you can do that add a second condition. What isn't working for you?

 

[rastogirachit]

Got it. Thanks a lot. that's what I was missing to add the second condition.