k_rasuri
asked on
string function to seperate full name
Hello all,
I am looking for a string function to seperate my lastname, firstname and middlename and put into three seperate columns. so here is my table
Table1:
FullName
Lym, Sherry Anne
like in the above example. i have a table in which there is a fullname column. the format of this colum is LastName, FirstName MiddleName. now i want to last name, firstname and middlename first initial, in three seperate columns. that would be something like this
ResultTable:
LastName FirstName MiddleInitial
Lym Sherry A
please provide me a sql query...thanks
I am looking for a string function to seperate my lastname, firstname and middlename and put into three seperate columns. so here is my table
Table1:
FullName
Lym, Sherry Anne
like in the above example. i have a table in which there is a fullname column. the format of this colum is LastName, FirstName MiddleName. now i want to last name, firstname and middlename first initial, in three seperate columns. that would be something like this
ResultTable:
LastName FirstName MiddleInitial
Lym Sherry A
please provide me a sql query...thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Determine what your delimiters are
2. Search for the same in your source column name; thus dividing the script into parts
3. Save the parts into various columns.