On 11 Feb 2013 09:57, Richard Casey wrote:
If the bad data in OrderQty is only blanks, this should work.

FROM datafile
WHERE SUBSTR(HEX(OrderQty),1,2) <> '40'

Bad idea for two reasons. If the Packed BCD represents an even-precision versus an odd-precision, the first digit is always zero; i.e. testing for '040' would be more appropriate. Besides that however, the 5P00 decimal value 40755 which is the Packed BCD value represented in storage as x'40755F', will *incorrectly* be omitted from the results; i.e. SUBSTR(HEX(OrderQty), 1, 2) = '40' and that is an entirely *correct* Packed Decimal representation.

Return to Archive home page | Return to MIDRANGE.COM home page