Modifying the fullname

Courtesy of Mr. Lemmen;

UPDATE contactbase SET fullname = ISNULL(lastname, '') + ', ' + ISNULL(firstname, '')

Of course you can update the contactbase with other values for the fullname as well.

Keep in mind that you NEVER update the Contact view, always the contactbase. Updating the contact view will cause problems.

Anyway, you should always make a backup of your database before making any modification to the database.

http://ronaldlemmen.blogspot.com/2006/07/modifying-fullname.html