Select datename(m,getdate()) would give you July.

John

-----Original Message-----
From: choudhary amit [mailto:[Email Address Removed]
Sent: Friday, July 25, 2003 11:21 PM
To: LazyDBA.com Discussion
Subject: Month Name?

Hi Everybody,
In SQL Server -2000, Is There Any Way to Get
MonthName By Giving No Of Month?
Thanks In Advance.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page