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"

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.

Your Answer:

Login to answer

Other forums

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

drop-down with sub-category appear
Hello,

i know how to build a simple dro-down list, im looking for a code when im gonna choose

Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&typ

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

HTML Form Server Side Validation
Hi, Im new here, im currently doing a website for a friend, and I have designed using snippets from

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does an

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess