In a completely unrelated note, as I was logging in a few minutes a go I noticed this was the second most popular thread of the day, LOL!, most of it was a conversation between George and Bill :).

>Hi Chuck,
>
>Just minor unrelated observation: if you're going to use alltrim(upper(yourfield)) in all case statements, just create a local variable, assign this to it and use it in case checking - you would save some time (though it would not noticable, I believe). Anyway, just to make your code more efficient.
>