>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
>

replace fieldz with icase(fieldz  =7, 97   ;
   ,    fieldz  =6, 84  ;
...
   ,   fieldz  =1, 24   ;
   ,   fieldz)