Re: case insensitive order by

A UDR (User Defined Routine) is any function which is written by the user and can be invoked directly like a stored procedure (stored function in universal server) or implicitly. They can overide built in functions which allows for support standard symbols to have different meanings, depending on type definition. For instance, the meaning of "=" can be overridden so that "Mc", "MCC" and "Mac" are considere the same. Also, they provide the basic support of UDT (User Defined Types) which provide the ability to define data types outside of the SQL built-in types. UDRs are fairly close to the "methods" as defined in SMALLTALK. They can consist of a Stored Function using SPL or a 'c' module. Work is currently being done to provide support for JAVA as well. When the 'c' module is invoked, the object module is loaded by the engine and executes as though it were part of the engine. They can also provide direct access to non-database media. For instance, the actual 'update' of the data could actually send a control sequence to thermostat control devices while the 'select' could actually be retrieving the current readings from heat sensors. --- Kinda 'Buck Rodgers' but it gives an idea of what's coming. Madison Pruet