Hi,

we are using SQL-Server 2000 with Visual Foxpro. Is there any equivalent function for VFP-Function:

WEEK(dExpression | tExpression [, nFirstWeek] [, nFirstDayOfWeek])

in SQL-Server?

I know datepart(week,date)-Function, I can set datefirst to 1 (monday for german standard), but I can't set any equivalent like nFirstWeek in VFP (I want that the first week has seven days, so 3 in VFP).

Bye,
Andreas