Implementing IF Condition Within a T- SQL UPDATE Statement up vote 10 down vote favorite 2 Using T- SQL, ...
stackoverflow.com