Home » SQL & PL/SQL » SQL & PL/SQL » how to split a full name seperate names
how to split a full name seperate names [message #202979] Mon, 13 November 2006 08:10 Go to next message
ramzi_j_h
Messages: 36
Registered: September 2006
Location: Jordan
Member
Hi
i want SQL statement to devide a name of a person for example into 3 or 4 seperate names

like this

"John peter smith"

into

"John"
"peter"
"smith"

thanks alot in advance
Re: how to split a full name seperate names [message #202983 is a reply to message #202979] Mon, 13 November 2006 08:15 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Cross post....

Other one

By
Vamsi
Re: how to split a full name seperate names [message #203011 is a reply to message #202983] Mon, 13 November 2006 09:28 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I don't think this rates 'Expert'.

Topic Locked.
Previous Topic: "ORA-01405" returned with .NET driver on Oracle server 9.2
Next Topic: Cant see the Table Name..
Goto Forum:
  


Current Time: Sat Dec 03 01:00:14 CST 2016

Total time taken to generate the page: 0.10321 seconds