Hi all, is it possible to use a Case statement in a Where clause ?, what I am trying to do , is , update a table using either field1 = somevalue or field2 = someothervalue depending on a flag setting

pseudo babble

update mytable
set fieldx = null
Where
If @MyFlag = 'Y'
field1 = somevalue
else
field2 = someothervalue

hope that makes sense