Like displays rows which doesn't match the condition or am i wrong.

From: Veerabasaiah C <veeracb_at_gmail.com>
Date: Fri, 14 Mar 2014 10:46:50 +1300
Message-ID: <CAKE9HuMVvNNCiVLDH57Eozc6XXrzAN+HSijvfHY7godUaWQ_Sg_at_mail.gmail.com>



SQL> select * from test where c1 like 'a1_%';

C1


a1_a2
a1_a3
a1_a4

SQL> insert into test values('a1a4');

1 row created.

SQL> select * from test where c1 like 'a1_%';

C1


a1_a2
a1_a3
a1_a4

a1a4

SQL> In the above select like displays "a1a4", for the search criteria it should display anything with the "a1_" but the last row doesn't even have a underscore.

--

Veerabasaiah C B
"Only put off until tomorrow what you are willing to die having left undone. - Picasso"

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 13 2014 - 22:46:50 CET

Original text of this message