Day of the Week Name Needed

[OAKEJ]

Is there something that will return the day of the week name, like in DATEPART or something. I know how to do it the long way I just don't want to if I don't have to

ex.
DATEPART("dw",GETDATE())=3 - result wanted is Wed

the only way I know how to do it is

CASE WHEN DATEPART("dw",GETDATE())=3 THEN "Wednesday" else
...

Thanks

 

[ca8msm]

DATENAME


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[PWise]

select DATENAME ( dw , getdate() )