Day of the week

Is it any function that return name of the day on week .. like Monday,
Tuesday etc.?
ThanksSELECT DATENAME(w, GETDATE())
Look into BOL for all the other date functions.
--
Thanks
Yogish|||DATENAME()
--
David Portas
SQL Server MVP
--