Link to home
Start Free TrialLog in
Avatar of JElster
JElsterFlag for United States of America

asked on

SQL Server - Help parsing name field

Hi..
I need help parsing a NAME field into 2 fields

the NAME field data looks like this

"LASTNAME : SMITH   FIRSTNAME:  JOHN"
"LASTNAME : DOE   FIRSTNAME:  Jane"

I need it parsed into   a LASTNAME and FIRSTNAME FIELD

LASTNAME           FIRSTNAME
SMITH                  JOHN
DOE                     Jane
ASKER CERTIFIED SOLUTION
Avatar of Lee Wadwell
Lee Wadwell
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial