Issue with Select Single *

Hi,

Following is my select single query

SELECT SINGLE *

FROM z_table

WHERE mprn_from LE iv_pod_id

AND mprn_to GE iv_pod_id.

mprn_from and mprn_to is of type NUMC, length 10

iv_pod_id is of type CHAR, length 50

Value in iv_pod_id is '120000043221967'. This is not present in z_table. When we check using se16 and put the value in mprn_from and mprn_to, obviously it is truncated to 1200000432 becuase the field length is 10, and no records are selected when we press F8.

But when the above select single statement is executed, sy-subrc = 0 is returned. Some random value from Z-table is selected. I have no idea why this is happening.

Nik