Thank you Tore et al who have responded. Truly appreciate all the input.
Im dusting off my old vfp hat so apologize if many changes are beyond my scope of experience hehe..in the past i have used alltrim because sometimes empty just would catch that pesky ghost space but like i said that was my experience many many moons ago...
Again thanks everyone
>>>ALLTRIM is used to often and on meaningless places. In fact, the statement
>>>
>>>..
>>> IIF(EMPTY(Sourcetable.fieldC), "No LIsting Provided", Sourcetable.fieldC);
>>>..
>>>
>>>would do, except Field_C is Varchar. Even then, most likely TRIM() will be enough.
>>
>>Too verbose. I'd prefer
>>
>>... evl(Sourcetable.fieldC, "No LIsting Provided")...
>>
>Thank you for reminding me, I had forgotten about evl().
Thanks in Advance.
J. Turner