Is there any way to table drive a case statement that has varying criteria and "IN" comparisons like this. I don't think there is but thought I'd seek other advice. I'm on SQL Server 2000, but soon moving to 2008.

WHEN F1='TKAAA.....'
AND F2='213000B'
AND F3='0317120'
AND F4 IN ('4997') THEN 'Value1'
WHEN F1 IN ('F3C6BB','F3C6BC','F3C6BD')
AND F3='209000C'
AND F4 IN ('2105','2106') THEN 'Value2'

Thanks!