RE: Like displays rows which doesn't match the condition or am i wrong.
From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Thu, 13 Mar 2014 21:52:52 +0000
Message-ID: <nc7fxfmwfsx884g2gk4nfnc8.1394747573426_at_email.android.com>
Underscore is a single-Character wildcard.
a1a4
Date: Thu, 13 Mar 2014 21:52:52 +0000
Message-ID: <nc7fxfmwfsx884g2gk4nfnc8.1394747573426_at_email.android.com>
Underscore is a single-Character wildcard.
Stephan Uzzell | MICROS Systems, Inc.
Database Administrator - Hosting Services
7031 Columbia Gateway Dr, Columbia, MD 21046
P: 443.285.8000x2345 | F: 443.285.8152
Veerabasaiah C <veeracb_at_gmail.com> wrote: 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:52:52 CET