Ivan Cruz wrote:

>delphigurusam wrote:
>
>
>
>> NEW.DISPLAY_NAME=UPPER(NEW.LAST_NAME)+', '+NEW.FIRST_NAME+'
>>'+NEW.MI;
>>
>>
>>
>>
>>
>
>Try
>
>NEW.DISPLAY_NAME=UPPER(NEW.LAST_NAME)||', '||NEW.FIRST_NAME||' '||NEW.MI;
>
>
>
>Ivan.
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>

It ran without error.
I'll strip out my app code that was updating this and see what happens.
Thx so much.
Sam H.