SQL Server types conversion

Question

Possible Duplicate:
sql server year

EXACT duplicate of sql server year

DECLARE @FINANCIALYEAR AS varchar(30) 
DECLARE @FINALFINANCIALYEAR AS int 

SELECT @FINANCIALYEAR=CONVERT(VARCHAR,YEAR(GETDATE())-2) + ', ' +   
CONVERT(VARCHAR,YEAR(GETDATE())-1) + ', ' +   
CONVERT(VARCHAR,YEAR(GETDATE()))  

set @FINALFINANCIALYEAR = CONVERT(int,@FINANCIALYEAR) 
print @FINALFINANCIALYEAR 

i want final output in int format so i'am doing above code but it gives me error plz help

Answer 1

FINANCIALYEAR is a string contains something like "2008,2009,2010". Then you trying to convert in to int. Obviously it will fail.