Re: Using LIKE with IN on an expression

Grant wrote:
> Hi,
>
> The following Statement:
>
> WHERE x.field LIKE (IN(%MyCommadelimetedValue%))
>
> Is that thecorrect syntax to perfom a comparison on values brought in
> from a selection combo box? (Iam assuming that Oracle is able to
> perform such an operation)
>
> Thanks
>
> Grant

It makes no sense whatsoever.

x.field is either LIKE something or it is IN one or more values.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org