Compare alphanumeric value

[Former Member]

Hi All,

Can you please advise me , how can i compare alphanumeric value.

I have a table entry where postalcode-from = DA1 0AA  and postalcode-to =DA9 0ZZ. I want to select value in between these two value.For example i want to select DA2 0AA.

My select query below.

v_input = DA2 0AA.

SELECT SINGLE transpzone FROM yoet_tpzone_map

*                                 INTO x_tptzone-transpzone

*                                 WHERE country = <fs_country> AND ( POSTALCODE_FROM LE v_input AND POSTALCODE_TO GE v_input).

Here its selecting  for value DA2 0AA.

Please advise me some logic for this.

Thanks

Satya

[kakshat]

Hi Satyaranjan,

Did you try using < (LT) and > (GT) instead of LE and GE?

Also, I guess you want to get all the values between the two values you mentioned. So, you shouldn't be using a SELECT SINGLE, rather you should be receiving the result set in an internal table.