Splitting Attributes


Posted on 16th Feb 2014 07:03 pm by admin

SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",

substr(I_NAME, INSTR(I_NAME,'O')+1) "Second part"

Did you know?Explore Trending and Topic pages for more stories like this.
FROM Enrollment

WHERE I_NAME like '%O%';
2 3 4

I_NAME First part Second part

--------------------
LIOU LIO U

I am just not sure why it’s only pulling one name from the table.
No comments posted yet

Your Answer:

Login to answer
347 Like 47 Dislike
Previous forums Next forums
Other forums

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

Mail form doesn't send Russian/Cyrillic characters correctly?
When someone enters foreign characters (like Cyrillic text, and Japanese/Chinese probably gives the

Namespace Problem
I'm having problem with a section of code with a variable namespace.

This code works fine:

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

Add_Months not Easy to Understand
Oracle is number 1, very fast and very easy. But....
OK, I think but have a problem, only 1 pro

Merger of 6 sister companies under one flagship company after go live
Dear Experts,
I need one help regarding Merger of sister companies of same group. currently we

Problem executing bash script using shell_exec
Hi there,
I created a bash script file using following code to convert doc documents to pdf using

using a loop help
Hi guys , i need some help. I have this loop :
while ($row = mysql_fetch_assoc($Result)) { ?&

Extract text from string
Hi folks,

I have a string that looks like this:

aaaaaaaaaa:
bbbbbbbbbb (ccccccccc)

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash