>>Hi Chuck,
>>
>>>Worked! I appreciate it very much. Thanks, CWH.
>>
>>I use the Empty function probably more than I use IF! Is this the first you've ever heard of it?
>
>Not the first I've heard of it, but after having been stung by this strange SET EXACT ON / OFF issue when using "=" to do character string comparisons, I have a feeling I'll default to IF EMPTY() if possible. Thanks again!

PMFJI--Empty() isn't automatically rushmore optimizable. If you are doing a select that has to be fast (or a count, or a scan-for) then you either need an index tag on empty(fieldname) or you need to say !field=="" or field>' '