how to return name of day 'Monday' from a date?

Hello,
Does sql Server (2k) have a function for returning the name of a day like in
.Net
date.DayOfW.ToString
returns say Monday. Or do I have to use a Case Statement with Datepart?
Thanks,
RichThere's a DATENAME function that's similar to DATEPART but returns names
rather than numbers.
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:972DE410-FE73-4248-B1CF-2D65F94B6465@.microsoft.com...
Hello,
Does sql Server (2k) have a function for returning the name of a day like in
.Net
date.DayOfW.ToString
returns say Monday. Or do I have to use a Case Statement with Datepart?
Thanks,
Rich|||Thanks. I knew there was a function. I used it once a ways back. Now need
to use it again. Just couldn't remember.
Thanks.
"Keith G Hicks" wrote:

> There's a DATENAME function that's similar to DATEPART but returns names
> rather than numbers.
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:972DE410-FE73-4248-B1CF-2D65F94B6465@.microsoft.com...
> Hello,
> Does sql Server (2k) have a function for returning the name of a day like
in
> ..Net
> date.DayOfW.ToString
> returns say Monday. Or do I have to use a Case Statement with Datepart?
> Thanks,
> Rich
>
>