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: a substring question

Re: a substring question

From: DanHW <danhw_at_aol.com>
Date: 1997/06/01
Message-ID: <19970601050900.BAA11977@ladder02.news.aol.com>#1/1 







Use the INSTR function...



instr(upper('lewis'),upper('Mr Lewis')) will return 3 because 'lewis'
occurs in 'Mr Lewis', and starts at position 3. If there is no match INSTR
returns a 0.



(Double check in the manual which one goes first, the string to be
searched for, or the string to be search in; I never remember and have
tolook it up every time I need to use this function).




Dan
Received on Sun Jun 01 1997 - 00:00:00 CDT












Original text of this message













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