JElster
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.