Greetings,

We are using Oracle 9i. Are regexp functions available in Oracle 9i, or
was that introduced with 10?

Given the following two strings:
str_a='5838 MISSION CENTER RD #C'
str_b='5838 MISSION CENTER RD C'

or
str_a='7576 PARKWAY DR APT #2A'
str_b='7576 PARKWAY DR APT 2A'

is it possible to write an expression in Oracle 9i that will return true
if the only difference between the two strings is the presence of the
'#' symbol?

Fester Bestertester 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 ....

HTH,
Brian
--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

Brian Peasland wrote:
Right...I had a feeling that's what I would need to do. thanks for
responding.

Fester Bestertester wrote:
Regular expressions have been available since version 8 in the
OWA_PATTERN package.
http://download.oracle.com/docs/cd/B...tt.htm#i999925
Not nearly as fast or robust as the 10g implementation but they are there.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
Oh, very cool! Now there's something I didn't know. I may not end up
using it right away, but it's good to know about anyway. Thanks.