|
-
Jan 16th, 2008, 03:53 AM
#1
Thread Starter
Hyperactive Member
How to get a part of the string ?
How can i get
1 out of '1 - Jack' or
26 out of '26 - Dave' or
436 out of '436 - Michael' ???
There is a blank space on either side of Hiphen (_-_). I want to get the numeric part of the string only, be it 1 digit 2 digit or whatever...
I am using Oracle9i SQLplus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|