CONVERT A SIGNED FIELD TO PACKED DECIMAL(7,0)

[TonyT]

SELECT SUBSTR(FIELD1,1,7), HEX(SUBSTR(FIELD1,1,7)) FROM FILEA THIS IS MY RESULT: 000012{ F0F0F0F0F1F2C0 000012{ F0F0F0F0F1F2C0 000015{ F0F0F0F0F1F5C0

[Guest.Visitor]

So Field1 is a character field? What determines the sign? It looks like your example is a file with 3 records, with values as below. Need more info about this. <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6b248370/0')