Re: case insensitive order by
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