regexp_like weirdness in 10G?

From: Ken Quirici <>
Date: Sun, 14 Feb 2010 12:55:46 -0800 (PST)
Message-ID: <>

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

Original text of this message