regexp_like weirdness in 10G?

Giganews Newsgroups
Subject: regexp_like weirdness in 10G?
Posted by:  Ken Quirici (kquiri…@yahoo.com)
Date: Sun, 14 Feb 2010

I'm getting this column contents (the column is a varchar2(200)):

'K+CS2(26)/DP'

matched by this:

regexp_like(<col-name>,'^(\d)+\(B|\d\).*DP.*')

Just in case, I also returned the column length and got 12, which is
exactly the number of
characters between the single quotes.

I thought '^' meant start-of-string, in this case, start-of-database-
column-string, so I
should not be getting a match with a string starting with 'K+CS'>

When I remove the '^' I get exactly the same results.

I'm running this test in TOAD.

Replies