As Mr Big in Sex And The City, he was the handsome businessman whose gentlemanly charm made Carrie Bradshaw - and millions of fans - fall in love with him.