>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")...