Re: Case insensitive searching.

Fuzzy <grant_at_towersoft.com.au> wrote in article <32546d8c.0_at_red.interact.net.au>...
> People,
>
> Has anyone out there tried to implement case insensitive searching
> using a nls module to fool the db? When I spoke to Oracle about this,
> they (honestly) suggested that the best way to it was to use SQL like
>
> Select blah from blah where
> ( name like 'SM%' or
> name like 'sm%' or
> name like 'Sm%' or
> name like 'sM%') and
> to_upper(name) = 'SMITH';

      |
  Has Oracle TO_UPPER function? May be UPPER.

>
> Foolishly, I was kind of hoping for a response from my server sometime
> this century, rather than go the way of the pharohs using the above
> method.
>
> Has anyone tried any other methods of achieving this. (I have a TAR
> currently open requesting an upgrade that supports case-insensitive
> searching, but I think I'm the 50000000th person to ask - and be
> declined!)

Why don't:

Select blah from blah where UPPER(name) like 'SM%';

-- 
G'luck !
-----------------------------------------
Garry M. FIlimonov
LASU TRINITI, Troitsk, MR, Russia
garry_at_triniti.troitsk.ru
7-(095)-334-0408