I need to do some code like th following:

SELECT
CASE #ProductType = "Windows NT Workstation" or "Windows 2000 Professional" or "Windows XP Professional"
CASE @ProductType = (something other than the above)
ENDSELECT

Or would this be better with an "IF"? I am not sure about using "OR" and I'm also not sure about evaluating strings with the = sign. Is there a better way to do it? This is all new to me who am used to UNIX shell scripting.