Re: case independent LIKE select?

You need to concatenate the wildcard with the result of the function call:

where UPPER(article_title) like UPPER(input_str)||'%';

hth,
John Greco

George P. <george.pierceNOgeSPAM_at_wcom.com.invalid> wrote:

>Unless I am missing something, you will just do a simple select
>statement as follows:
>
>select *
>from article_table
>where UPPER(article_title) like 'UPPER(input_str)%';
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Jan 21 2000 - 09:03:33 CST