mssql get all emails and phone numbers from address column : A table in MSSQL looks like

    sn|name| address                                  |
    ------------------------------------------------
    1 |abc| new street, ND, homeemail@email.com 
        | work workemail@email.com, Contact numbers
        | Home phone 0019827343, Mobile 990288394 
    2 | ..

The output should display
 

    sn| name| phone1 | phone2 | email1 | email2|
    ---------------------------------------------

Any TSQL command ? 
