lookup to check range ?

[vikind]

hi,

I have a field from source acct_number of type string now i want to do a lookup
on a table which has the fields acct_start_num and acct_end_num and both these
fields are of type string. how do i acheive the condition where
acct_number >= acct_start_num set flag to 1
acct_number <= acct_end_num set flag to 2
i am not sure if lkp override would be able to do this..
as both the fields with which i want to compare with are strings.
unless its a number i cannot check if its in that range.

thanks for ur help

 

[blom0344]

Basically you need to fetch the values from the lookup table and then convert these and the acct_number to numericals and THEN apply the logic to either set flag to either 1 or 2.
I presume there is another field that is used for the condition?

Ties Blom
Information analyst
tbl@shimano-eu.com