>>I guess the only limit is the limit for a procedure's total size.
>>
>>I'd also say that it doesn't matter (anymore) if a chr or num is "faster" because in today's CPUs the difference wouldn't be noticeable. Remember, you aren't necessarily executing all the CASEs every time.
>>
>>cheers
>
>Good point that you and Borislav made about the size of the procedure.
>I don't think I will hit it, yet, but need to consider it.
>
>Thank you for your input.
Dmitry,
I said "old", you use VFP9
HELP:
Maximum size of compiled program modules - Limited by available memory
So I think you couldn't bother about this, but I am veeeery lazy too and I think programing 100 CASEs is more complicated and difficult to maintain then EXECSCRIPT(SomeField) ...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.