SQL where clause reference modification

[SDas]

Sudhakar, try:

SELECT * FROM DMG.CLAIMS_USPS_TRANS
WHERE BUSINESS_KEY liKE '0050075135%';

or

SELECT * FROM DMG.CLAIMS_USPS_TRANS
WHERE substr(BUSINESS_KEY,1,10) = '0050075135';

The LIKE is more efficient if BUSINESS_KEY is Indexed.