I actually just jumped into the thread at that point, never read other answers and didn't even think of it in terms of best solution. Just thought it was novel and was intrigued that it took me a minute to get what was going on. <g>
>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
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.