index on left(sponsor_id,4) + str(val(substr(sponsor_id,5,8))) + ; PADR(CHRTRAN(substr(sponsor_id,5,8), [0123456789], []), 4)...>I need to index a field that contains values like:
>index on left(sponsor_id,4) + str(val(substr(sponsor_id,5,8))) to temp >>almost works but misses the alpha in the last position.