Re: Oracle vs Sybase

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: 2000/03/29
Message-ID: <38e1e967.7534271@news-server>#1/1

On Tue, 28 Mar 2000 13:49:50 -0700, Tim Uckun <Malcontent_at_msgto.com> wrote:

>This would not work because I want to keep the data in a case sensitive
>manner for reporting purposes.
>

Sorry to butt in, Tim. But wouldn't a VIEW with the appropriate function (upper) applied to the columns solve your problem? Have you looked into using that? It would preserve your existing access queries. And you can always order by the results of a query on a view: the sort applies to the result set, not the original data.

HTH Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Mar 29 2000 - 00:00:00 CST