SQL Query: How to split one field into two

I have a simple query that is retrieving a name field from a table. There is NOT an individual first name and last name field; the table value is firstname;lastname. During the SELECT how can I split firstname;lastname into two columns?

Microsoft SQL Server 2008

Last Comment

kbios

8/22/2022 - Mon

dsacker

4/17/2015

SELECT  LEFT(name, CHARINDEX(';', name) - 1)            AS FirstName,
        SUBSTRING(name, CHARINDEX(';', name) + 1, 80)   AS LastName
FROM    YourTable

Open in new window

This makes a hard assumption that there will always be that semicolon there.

ASKER CERTIFIED SOLUTION

Leo Torres

4/17/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts