tia_kamakshi
asked on
Substring and Index of in MSSQL 2005
Hi,
I am using MSSQL 2005
I have complete Names in table column of the database
I wanted to seperate firstname and lastname. They all are , seperated
I mean if I have Jain, Akalank
here 'Jain' is the last name and 'Akalank' is the first name
And more names are
Jain, Akalank
Soubigou, Alban
Plattner, Albert
Klatt, Alexander
Simon, Alex
David, Alexandre
Holness, Andrew
Evra, Antoine
Stracke, Armin
Pathammavong, Arom
Savaria, Benoit
Mueller, Boris
Abitbol-Zouari, Caroline
Eck, Christian
Pierce, Daniel
De Giorgio, Domenicantonio
Floridia, Emanuele
Davidson, Emma Louise
De Palma, Federico
Milio, Francesco
Ortone, Francesco
Melka, Frederic
Wilson, Glenn
Rodriguez San Pedro, Jaime
NULL
How can we substring these names in 2 columns
Please help me with query
Many Thanks
I am using MSSQL 2005
I have complete Names in table column of the database
I wanted to seperate firstname and lastname. They all are , seperated
I mean if I have Jain, Akalank
here 'Jain' is the last name and 'Akalank' is the first name
And more names are
Jain, Akalank
Soubigou, Alban
Plattner, Albert
Klatt, Alexander
Simon, Alex
David, Alexandre
Holness, Andrew
Evra, Antoine
Stracke, Armin
Pathammavong, Arom
Savaria, Benoit
Mueller, Boris
Abitbol-Zouari, Caroline
Eck, Christian
Pierce, Daniel
De Giorgio, Domenicantonio
Floridia, Emanuele
Davidson, Emma Louise
De Palma, Federico
Milio, Francesco
Ortone, Francesco
Melka, Frederic
Wilson, Glenn
Rodriguez San Pedro, Jaime
NULL
How can we substring these names in 2 columns
Please help me with query
Many Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER