on 10-27-2009 12:29 PM
I have a database column which contains data similar to this:
DECRIPTION
Lemons (1324)
Oranges (21)
Bacon (3421442)
I would like to produce an object which will return in a query, the text without the numbers:
i.e.
DESCRIPTION
Lemons
Oranges
Bacon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This nearly worked, but in fact some of the descriptions have more then two words for example:
Green apples (282)
Big Yellow lemons (2145)
Hi,
The syntax works whatever the number of words. I cut the text at the parenthesis level.
Didier
Hi Joe,
Which database are you using?
Oracle 10g...sorry I forgort to mention that.
NB as can be seen the text length and number length varies
Try this syntax:
SELECT substr(DESCRIPTION, 1, instr(DESCRIPTION, " (")) FROM MyTable
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.