View Single Post
 
Old August 18th, 2008, 06:07 AM
kalyanykk kalyanykk is offline
Authorized User
 
Join Date: May 2008
Location: Hyderabad, AP, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to kalyanykk
Default Converting month name to month number

Hi All,
       I want to convert a month name to month number in sql2005.

For example: My query returns july as 'JUL' and august as 'AUG'.
Now my problem is i have to show 'JUL' as '7' and august as '8' in
one report.
I dont want to use case statement. Is there any built in function for this.