Re: Use like clause more then once
- From: Jeremy Smith <godtoall@xxxxxxxxxxx>
- Date: 29 May 2007 11:17:02 -0700
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.
.
- Follow-Ups:
- Re: Use like clause more then once
- From: DA Morgan
- Re: Use like clause more then once
- From: stephen O'D
- Re: Use like clause more then once
- References:
- Use like clause more then once
- From: Jeremy Smith
- Re: Use like clause more then once
- From: stephen O'D
- Use like clause more then once
- Prev by Date: Re: Use like clause more then once
- Next by Date: boolean in caluclations
- Previous by thread: Re: Use like clause more then once
- Next by thread: Re: Use like clause more then once
- Index(es):
Relevant Pages
|
|
