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
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.