SELECT LEFT(name, CHARINDEX(';', name) - 1) AS FirstName,
SUBSTRING(name, CHARINDEX(';', name) + 1, 80) AS LastName
Select allOpen in new window
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent
Open in new windowThis makes a hard assumption that there will always be that semicolon there.