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.)
Register Hereor login if you are already a member
Discuss This Question: