UPDATE
  taClientContacts
SET
  ContactType       = @aContactType,
  TypeID            = @nTypeID,
  Notify            = @bNotify,
  Title             = @aTitle,
  FirstName         = @aFirstName,
  Surname           = @aSurname,
  Position          = @aPosition,
  Email             = @aEmail,
  TelephoneAreaCode = @aContactAreaCode,
  TelephoneNo       = CONCAT(@aContactTelA, @aContactTelB)
WHERE
  (ContactID = @nContactID)
