LIKE, IN, BETWEEN

Item in a list

WHERE Id IN(2, 10, 4)

WHERE Id BETWEEN 4 AND 10 -- only works for numbers

Subset of text

SELECT * FROM SchemaName.TableName
WHERE [Name] LIKE '%feeb' -- search for anything ending with feeb

Note: search is fastest when the wildcard is at the end aka 'Production%'