How to populate a DisplayName field on Profile using First and Last Name

Version 1

    Details

    How to populate a DisplayName field on Profile using FirstName and LastName field values?

    Example:
    FirstName = John
    LastName = Doe
    DisplayName needs to be:  John Doe


    Resolution

     

    Back up the HEAT database prior to running the following Update query:

    UPDATE Profile

    SET DisplayName = FirstName+ ' ' +LastName