SELECT
  ContactType,
  TypeID,
  Notify,
  Title,
  FirstName,
  Surname,
  Position,
  Email,
  TelephoneAreaCode AS ContactAreaCode,
  TelephoneNo,
  LEFT(TelephoneNo, 3) AS ContactTelA,
  MID(TelephoneNo, 4, 10) AS ContactTelB
FROM
  taClientContacts
WHERE
  (ContactID = @nContactID)
