Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Search in string from right

Re: Search in string from right

From: <marpe1974_at_yahoo.se>
Date: 18 Apr 2006 04:31:13 -0700
Message-ID: <1145359873.410896.167190@g10g2000cwb.googlegroups.com> 





Thanks Sybrand!



It works fine by setting a negative position as the start parameter:



SELECT SUBSTR(RESOURCESTRING,1,INSTR(RESOURCESTRING , '-', -1)-1)

FROM FSA.ACCESSLOG



WHERE INSTR(RESOURCESTRING , '-')>0 AND TYPE=2 AND RESOURCETYPE=1


Happy, happy, happy!
Received on Tue Apr 18 2006 - 06:31:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US