• I recommend avoiding unnecessary string conversions/usage, and dependencies on language and/or other SQL settings.

    Not sure what the h "N" means, but I still suggest this style of code instead:

    WHERE DATEDIFF(DAY, 0, N) % 7 IN (5, 6)

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.