>>>They both wrong and both right because they use there own definition of the WEEK(). See http://www.windowsitpro.com/SQLServer/Article/ArticleID/14340/14340.html, for example.
>>>
>>
>>I don't agree.
>
>You may not agree, but a standard is a standard, and the international standard is that week 1 is the first week of the year to contain at least four days. But nobody can push a standard on you, so if you want to set your own standard, so to say, be my guest. I know that not all countries follow this standard, that's one of the reasons why VFP gives you the additional parameteres to the WEEK() function.
>
>As I see it, there is no right or wrong here, the question is whether you want to follow the international standard or not.
>
>

My standard ? where have I written this?

MSSQL don't support the ISO standard.
This is not "wrong", but "lack","issue","insufficient"....
To say "wrong" it is wrong.

On VFP :

WEEK(DATE())   && this is not the ISO standard and it is wrong
WEEK(DATE(),2) && this is the ISO standard, and it is correct
WEEK(DATE(),3) && this is not the ISO standard and it is correct