Conversion failed when converting the varchar value to int

Question

Hi  while executing the below query getting error declare @thirdpartyvendorid varchar(1000) declare @thirdpartyvendoridNew varchar(1000) select @thirdpartyvendorid = a.thirdpartyvendorid from dbo.stageloaninfo a (nolock) where slid='160897' select @thirdpartyvendoridNew = COALESCE(@thirdpartyvendoridNew + ' ''') +CONVERT(VARCHAR V.VendorID) from Vendors V where V.VendorID in (CAST(@thirdpartyvendorid as varchar )) and VendorType = 4 select @thirdpartyvendoridNew Anybody pls help Conversion failed when converting the varchar value '11301117' to data type int.

Raja T · Answer

Hi Gova Please check below query declare @A varchar(50) declare @B varchar(50) set @A='500' set @B='500' Select (convert(int@A)+convert(int@B)) as Total Output like Total 1000 So you can use convert function : Select convert(int[Column1]) More details checkout below urls http://stackoverflow.com/questions/7973224/how-to-convert-varchar-to-int-in-sql-server-2008 http://stackoverflow.com/questions/15977911/sql-server-converting-varchar-to-int Thanks