| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to use "where in" to select from a list
In article <3885fb0a.87777817_at_news.nanospace.com>,
izblank_at_yahoo.com wrote:
> '2,' is not selective enough either - you'll get a match on 12 as well
Yes, I realized that somewhat belatedly. :)
> :-(. So you have to look for ',2,' . And to make allowance for the
> first and last items in the contents, make it like this:
>
> where instr(','+contents+',', ',2,') >0
Ah, I didn't know you could do that. Thanks!
-Jonathan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 20 2000 - 10:52:09 CST
 |
 |