Home Forums SQL Server 2005 SQL Server 2005 General Discussion convert the string value into varchar RE: convert the string value into varchar

  • December 9, 2009 at 2:51 am

    #1089700

    declare @i varchar(25)

    set @i='2009-NOV'

    select datename(month,cast(@i as datetime))

    blog: http://sarveshsingh.comTwitter: @sarveshsing