InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 01:28:30 GMT20http://www.sqlservercentral.com/Forums/Topic1035716-392-1.aspxExcellent. Thanks for your help.Thu, 16 Dec 2010 04:11:35 GMTzuma01http://www.sqlservercentral.com/Forums/Topic1035716-392-1.aspxDECLARE @NextMonth AS nvarchar(7)SET @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)if @nextmonth = 'Jan-10' set @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate())+1, 2)else set @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)select @nextmonthThu, 16 Dec 2010 03:39:40 GMTSachin Nandanwarhttp://www.sqlservercentral.com/Forums/Topic1035716-392-1.aspxHi,I am trying to change a variable based on the results of the same variable. Is this possible or do I need to go about this some other way.Code below: DECLARE @NextMonth AS nvarchar(7)SET @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)if @nextmonth = 'Jan-10' then @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()),+1, 2)else s @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)select @nextmonthThu, 16 Dec 2010 03:16:21 GMTzuma01