title: T-SQL substring - separating first and last name
body: <p>I have a column which has FirstName and LastName together. I'm writing a report to separate the FirstName And LastName. How do I get the FirstName and LastName separated in T-SQL?</p>