string functions in oracle
i’m having a column called name,
for example the data in the column name are
name
-------
john britto
George bush
But I need to display the first half(i.e upto the space)like,
Name
--------
John
george
Software/Hardware used:
Software/Hardware used:
ASKED:
May 26, 2008 10:37 AM
UPDATED:
May 26, 2008 7:36 PM
Answer Wiki:
You can use the SUBSTR and INSTR functions to do this.
<pre>SELECT SUBSTR(NameColumn, 1, INSTR(NameColumn, ' ', 1, 1))
FROM Table;</pre>
(This is untested.)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
