Error : Arithmetic overflow error converting expression to data type int

See more:

SQL-Server-2005

SQL-Server

Hi Friends,

I m getting the below error while i m running a procedure

Error : Arithmetic overflow error converting expression to data type int.

Here is my query

DECLARE @COUNT INT, @INVOICENO VARCHAR(100)

SELECT @COUNT = isnull( MAX(CONVERT(BIGINT,replace ( substring(INVOICENO,0,case when charindex('-',INVOICENO,0)  > 0 then charindex('-',INVOICENO,0) else len (Invoiceno) + 1 end  ),' ', ''))),0) ,@EmployerId = MAX(SUPERVISORNAME) fROM TBL_NEW_TIMESHEET
WHERE CONTRACTORID = @CONTRACTORID AND INVOICENO IS NOT NULL

Thanks