Compare alphanumeric value

Former Member — Wed, 20 Mar 2013 11:22:01 GMT

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

Re: Compare alphanumeric value

kakshat — Wed, 20 Mar 2013 11:53:07 GMT

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.

topic Compare alphanumeric value in Application Development and Automation Discussions

Compare alphanumeric value

Re: Compare alphanumeric value