→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
laurentiun
Engaged Sweeper III
Hello,

I'm trying to select only computers with specific names. My query is like this:


select ...
tables
FROM tblAssets
inner join
inner join
WHERE (tblAsset.AssetName = '%AAA%' or tblAsset.AssetName = '%BBB%' or tblAsset.AssetName = '%BBB%') ..... I do 6 filters but the result is showing only the first 3 or only 3 of the filtered assets. Also if one of them have NULL values, I want to show.

Could you please assist?

Thank you.

1 REPLY 1
RCorbeil
Honored Sweeper II
If you're using wildcards ("%"), you want to do a LIKE comparison, not =.
WHERE (tblAsset.AssetName IS NULL
OR tblAsset.AssetName LIKE '%AAA%'
OR tblAsset.AssetName LIKE '%BBB%'
OR tblAsset.AssetName LIKE '%BBB%')

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now