Hi,
Try this...
select datename(weekday,getdate())

Cheers,
Kannan M

----- Original Message -----
From: "Parag Kulkarni" <[Email Address Removed] <[Email Address Removed] Tuesday, May 14, 2002 9:45 PM
Subject: Select Day As String


> Hi Freinds,
>
>
> I need to get day in string format ( AS SUNDAY ) for a
> given date.I checked the BOL but couldnt find it.Does
> somebody knows this.I am using SQL 2000.
>
> Thanks in advance
> Parag
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
>
MS Sql Server LazyDBA home page