Re: SQL..

From: David Brenchley <dbrenchley_at_erudite.com>
Date: 1997/01/27
Message-ID: <01bc0c64$b44ded00$090364c8@David.erudite.com>#1/1

try code like '3%' or code like '7%';

code cannot be like 3% and 7%, its one or the other.

Stella <sfong_at_letterbox.com> wrote in article <01bc074a$fa13b0a0$6303fe0a_at_ppp.ncs.com.sg>...
> Why no rows selected when I have this statement?
>
> select desc, code from table_a where name = 'ABC'
> and code like '3%' and code like '7%' ;
>
> Please reply.
>
> Thanks
>
> Stella
>
>
Received on Mon Jan 27 1997 - 00:00:00 CST