Home Forums SQL Server 2008 SQL Server 2008 - General How to select first name only ? RE: How to select first name only ?

  • May 30, 2015 at 4:25 am

    #1801804

    do something like

    select left(Name,charindex(' ',name)) from mytable

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]