I thought Sergey's was best and probably most stable,
although I don't know if/how much icase()-perf
degenerates for the cases at the end.
Pretty sure it is better than the string-massage

my 0.001 €

thomas


>Took me a second to get what you were doing but I have to say that is very clever. Just plain cool.
>
>>>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