splitting String First and Last Names

Version 1

    I have Data like

     

    Name

    ----------

    Parameshwar Reddy

    Sandeep Nimma

    john paul

     

    Split First name

    ------------------------

    LEFT([ Name],(FIND([ Name],' ')))   o/p:-Parameshwar

     

    Split Last Name

    --------------------------

    MID([ Name],FIND([Name],' '),LEN([ Name]))  o/p:-Reddy