I have a table where I am trying to determine a resulting value from several fields. I am running into an issue where the case statement is not correctly determining the value. Can someone please help? The code is below. The results should be the first one should be ROHS2_Unknown and the second should be servex_2.01, but they both are pointing to servex_2.01.
SELECT [Title],[Material Number],
WHEN  = '1' OR  = '1' OR  = '1' OR  = '1' OR  = '1' OR  = '1' OR  = '1' OR  = '1' AND  = '1' THEN 'servex_2.01'
END AS ROHS2_STATUS,*