>Dear All,
>I know it sounds crazy but how can make a conversion such as this one
>instead of typing the following will it be possible to do it in a loop
>Thanks to all
>
>

>If  fieldz  =7  replace fieldz  WITH 97  
>If  fieldz  =6  replace fieldz WITH 84  
>If  fieldz  =5  replace fieldz WITH 74  
>If  fieldz  =4  replace fieldz WITH 59 
>If  fieldz  =3  replace fieldz WITH 50  
>If  fieldz  =2  replace fieldz WITH 34  
>If  fieldz  =1  replace fieldz WITH 24
>

IF BETWEEN(fieldz, 1, 7)
REPLACE fieldz WITH VAL(SUBSTR('24345059748497', fieldz * 2 - 1, 2) )
ENDIF