>>>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>' '
I appreciate the info very much. Thanks, CH.
Chuck Henry