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: String Comparisons in Oracle 9i

Re: String Comparisons in Oracle 9i

From: Fester Bestertester <whatmeworry_at_mad.net>
Date: Mon, 22 Oct 2007 12:38:02 -0700
Message-ID: <ffiu58$qjh$1@gondor.sdsu.edu> 





Brian Peasland wrote:


> Regular expressions were introduced in 10g.

> 

> In your example, you can use the TRANSLATE function to remove the '#' 

> sign and see if the two strings are equivalent:

> 

> IF TRANSLATE(str_a,'#','') = TRANSLATE(str_b,'#','') THEN ....




Right...I had a feeling that's what I would need to do. thanks for 
responding.
Received on Mon Oct 22 2007 - 14:38:02 CDT












Original text of this message













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