Re: input parameters

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Wed, 4 Apr 2001 12:07:41 +0100
Message-ID: <986382483.16626.0.nnrp-12.c30bdde2@news.demon.co.uk>

Surely, however, using wildcards in this manner would negate the use of an index - if applicable. This *may*, depending on the situation, result in a performance deficit...

Happy to be wrong on this however... :-)

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3ACAB708.B145F0F7_at_exesolutions.com...
> Thanks. I assumed it wouldn't work and didn't even try. Very interesting.
>
> Start off ignorant enough and you can learn something new each day.
>
> Daniel A. Morgan
>
> Mike Moore wrote:
>
> > try:::
> >
> > where a.name like nvl('&name','%')
> > or b.parsed_city = nvl('&city','nosuchcity')
> >
> > etc, you get the idea
> >
> > if you wanted no input on city to match any city you could have said:::
> > and b.parsed_city = nvl('&city',b.parsed_city)
> >
> > didn't actually know if it would work, but tried it and it does!
Received on Wed Apr 04 2001 - 06:07:41 CDT