Subject Re: [firebird-support] help with trigger
Author Ivan Cruz
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.