regexp_like weirdness in 10G?

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

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


matched by this:


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.