How did you convert the data into SQL in the first place? Possibly the
problem occurs in translating the EBCDIC character set into a VARCHAR
column. I would suggest that the conversion is best done before the data
reaches your database - convert the packed data to numerics as part of an
Different systems also implement variations of the packed decimal format -
e.g. different ways of representing the sign nibble. Maybe you have one of
I recommend you check out a standard ETL tool that will help you convert and
validate this data. DataJunction (www.datajunction.com) does ...