ODBC: ERROR [S1000] [SAP AG] [6930] attribute value is not a number

[Former Member]

Can anyone please help me to understand why I'm having the error above after I add the "Where" clause to my query? Without the "Where" clause it works.

Thank you!

SELECT select CAST(T0."Segment_0" as bigint) as "AcctNo" , T0."AcctCode" , T0."AcctName" AS "Account Name" ,
case WHEN CAST(T0."Segment_0" AS bigint) BETWEEN 41000000 AND 59999999 THEN 'descr1'
WHEN CAST(T0."Segment_0" AS bigint) BETWEEN 60000000 AND 69999999 THEN 'descr2'
WHEN CAST(T0."Segment_0" AS bigint) BETWEEN 70000000 AND 79999999 THEN 'descr3'
WHEN CAST(T0."Segment_0" AS bigint) BETWEEN 80000000 AND 89999999 THEN 'desc4' ELSE 'UNKNOWN' END AS "Subcategory"

FROM xx LEFT OUTER JOIN xx2 ON T1."Account" = T0."AcctCode"
INNER JOIN xx3 T2 ON T2."Id" = T1."Id"
WHERE CAST(T0."Segment_0" AS bigint) BETWEEN 41000000 AND 59999999

[pfefferf]

What type has the column "Segment_0"? Are there any entries in the column which cannot be converted to a BigInt, what I would assume?

Regards
Florian