Date of First Day in Week

I need to write a user defined function that will return the date of the first day of a week when provided with the week number. I had an idea of using a while loop with that will keep adding 1 day from January 1st until the week number (found via the DATEPART function) is equal to the supplied week number. Not sure if this is the best way though - any ideas?

Donald.

try this

http://databasejournal.com/scripts/article.php/3392851

Excellent, exactly what I was looking for! Many thanks!