Prince Andrew, Duke of York The second-oldest son of Queen Elizabeth II Married: Sarah Ferguson on July 23, 1986, in a spectacular wedding that drew a television audience of some 300 million. They divorced in 1996 after an ongoing public drama that included the publication of topless photos of "Fergie." Children: Two daughters, Beatrice Elizabeth Mary, and Eugenie Victoria Helena. Briefly noted: Andrew, during a stint in the Royal Navy, was a helicopter pilot and served aboard the HMS Hermes during the Falklands War in 1982. Andrew had a memorable affair with Koo Stark, an actress who had appeared in soft-core pornographic films. British tabloids dubbed him "Randy Andy."