Re: case insensitive order by

SaTriGuy wrote: > > Universal Server (lev 9.0) allows a UDR (user defined routine) to be used > within > the where clause. Additional, an index can be defined to be the output of > such a > routine. That is, it is possible to build an index of all uppercase > characters, and > to search on uppercase. Also, it is possible to create an 'equality' > logic within > this UDR which causes prefixes such as Mac, MAC, Mc, etc. to be considered > equal. Thus it is very easy to allow a search of McDonald to consider all > of the > various ways of spelling Mc to be considered the same. > > For case insesitive searches, the systax would be: > > Select * from name where upper(name) = "JONES";> > For the index the syntax would be: > Create index namidx on name (upper(name));> > Madison Pruet It sounds as if you can basically write a small function to be called by a where clause. Is that correct? Is it a stored procedure?