>Appearently you can issue SET DATEFIRST from within a UDF, although I can't find that explicitly stated in the BOL anywhere. Have you checked MSDN?
>
>-Mike
>

Did you mean to say "you cannot issue SET DATEFIRST from within a UDF"?. BOL in CREATE FUNCTION Remarks section states "Statements not in this list are not allowed in the body of a function:" and SET statements aren't in the above mentioned list.