Thanks for your quick response!
We are accessing a
database backend to some software we use, and have no idea whether it's
relational or transactional, and we also don't have access to the
definitions. However, looking at the Control Center we can tell the
column is a Double (sorry I said Decimal earlier), no precision and
scale are listed.
Unfortunately we can't make the other side a decimal because of what's stored in the column. The ID field has 2 to 3 IDs concatenated together, none of a specific length or type, so if we do that we get an error because it can't convert text to decimal.
select * from "BKARINVL"LEFT JOIN "ISNOTES" ON
cast("BKARINVL"."BKAR_INVL_INVNM" as char(5))=
cast("BKARINVL"."BKAR_INVL_SCCOG" as char(6)) =