0 - 2 of 2 tags for bad data

Hi
we have an amount column that is defined as varchar.
The data coming in has
example:
-5.00000000000000E 000
-0.45
1
 

Hello

I'm trying to run the following query and keep getting the above error message after the query has been running for a minute or so.

I've tried running it one where clause at a time, have removed the case when and fiddled around with it to try and identify where it is going wrong.

If anyone could help me I'd really appreciate it.

SELECT
T1.Call_Date
,(t1.Trading_Code||((t1.Account_Number/10)(FORMAT '9999999')))
,T1.Call_Type
,T1.BU_Desc
,SUM(CASE WHEN T4.Department_Group_Code IN ('M','W') THEN 'Fashion'
WHEN T4.Department_Group_Code IN ('F') THEN 'Footwear'