There are two parts for problem.

First you should use DATEPART(dw, @YourDate) to determine the day of the week of the specific date, in this case it's 02-01-2006 which is a...

thanks for the reply! do you mean if it's a simple update query as what I mentioned, it won't suffer a performance issue, even for a mass update?