No I want to ask about oracle : Lets say I have three rows with value as 
1)121/2808B|:6081
2)OD308B|:6081_1:
3)008312100001200.
 I want to display value only till 'B' but want to exclude after B
as you can see in above eg
from  121/2808B|:6081 I want only 121/2808B
OD308B|:6081_1: only OD308B
and 
008312100001200|:6081_1 only 008312100001200.
Thanks for the Help.