UPDATE
  taClientBranches
SET
  ClientID          = @nClientID,
  BranchName        = @aBranchName,
  TradeName         = @aTradeName,
  LabourNetBranchID = @nLabourNetBranchID,
  MapReference      = @aMapReference,
  IsHeadOffice      = @bIsHeadOffice,
  BranchStatus      = @nBranchStatus,
  NoOfEmployees     = @nNoOfEmployees,
  RoundTripDistance = @nRoundTripDistance,
  FreeKiloDistance  = @nFreeKiloDistance,
  Address1          = @aAddress1,
  Address2          = @aAddress2,
  Address3          = @aAddress3,
  Address4          = @aAddress4,
  Address5          = @aAddress5,
  TelephoneAreaCode = @aTelephoneAreaCode,
  TelephoneNo       = CONCAT(@aTelephoneTelA, @aTelephoneTelB),
  FaxAreaCode       = @aFaxAreaCode,
  FaxNo             = CONCAT(@aFaxTelA, @aFaxTelB),
  OtherAreaCode     = @aOtherAreaCode,
  OtherTelNo        = CONCAT(@aOtherTelA, @aOtherTelB)
WHERE
  (ClientBranchID = @nClientBranchID)
