I want to have a NAME field in my table that is based on three other fields - FIRSTNAME, LASTNAME, COMPANYORG.

If COMPANYORG is blank, then NAME=LASTNAME, FIRSTNAME.
If not blank then NAME=COMPANYORG.

I do this right now in various parts of my customer maintenance screens. What I want to know if there's a really neat way to do it inside the database itself using a stored procedure or validation rule, or something else I don't know about...