Re: Use like clause more then once

Currently 9i, will be moving to 10g this year. I tried joining the tables and doing to like statements, but it would give back zero records.

SELECT distinct srv.SERVER_ID,srv.SERVER_NAME,srv   FROM serverdb.servers srv inner join services svc on srv.SERVER_ID = svc.SERVER_ID
 WHERE (svc_display_name LIKE '%Microsoft Exchange%' and svc_display_name LIKE '%TSM%') and

         status_id = 1

If I did only one like at a time it should have around 200 records returned. So I assume that oracle doesn't like 2 or more like staments in the same where statement. Received on Tue May 29 2007 - 13:17:02 CDT