Re: Wildcards and case insensetivity...Please help!!

From: Geoff Muldoon <gmuldoonNoSpam_at_scu.edu.au>
Date: Tue, 24 Jul 2001 03:39:10 GMT
Message-ID: <3b5cec56.17656859@nntp.scu.edu.au>

On 24 Jul 2001 03:11:30 GMT, "John Smith" <someone_at_somplace.com> wrote:

>Hi,
>does anyone have a better way to get around the problem of being able to
>search for
>case insensetive data when using the like and % wildcard???
>
>ex.
>
>text ==> 'Rochester'
>text2 ==> 'rochester'
>
>search ==> '%rochester%' ==> returns ==> only 'rochester'

Use case conversion:
where upper(column_name) like upper('%input_string%') or
where lower(column_name) like lower('%input_string%')

Geoff M Received on Mon Jul 23 2001 - 22:39:10 CDT