Re: SQL code problem

--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%' ;

Try changing code as follows: "and code like '3%' OR code like '7%' ;

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

          Home: AlexJent_at_aol.com Received on Sun Jan 26 1997 - 00:00:00 CST