CREATE TABLE #Dw(Color VARCHAR(20),[Revision Number] INT)
INSERT INTO #Dw
SELECT 'Black', 9843 UNION ALL
SELECT 'Blue', 3970 UNION ALL
SELECT 'Grey', (null) UNION ALL
SELECT 'Multi', 3926 UNION ALL
SELECT 'NA', 28919 UNION ALL
SELECT 'Red', 4949 UNION ALL
SELECT 'Silver', 3424 UNION ALL
SELECT 'Silver/Black', (null) UNION ALL
SELECT 'White', 568 UNION ALL
SELECT 'Yellow', 4799

SELECT Color,[Revision Number] FROM #Dw WHERE Color NOT LIKE 'b%' AND Color NOT LIKE 's%'
/*Results:
Color	Revision Number
Grey	NULL
Multi	3926
NA	28919
Red	4949
White	568
Yellow	4799 */