regexp_like weirdness in 10G?

From: Ken Quirici <kquirici_at_yahoo.com>
Date: Sun, 14 Feb 2010 12:55:46 -0800 (PST)
Message-ID: <93c040f3-f74f-4175-8e9e-33111eaa3447_at_t42g2000vbt.googlegroups.com>

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. Received on Sun Feb 14 2010 - 14:55:46 CST