Subject Re: [IB-Architect] Syntax for case insensitive sort
Author Kim Madsen
The question is.... do you want to do it the Access way or the Oracle
way :)

I know several of you are flaming Oracle... but its actually a quite
fast and stable database widely used (why.... because it actually
does work), and I think IB should compete against Oracle more than it
should try to mimic Access!

Why to reinvent the wheel when somebody has allready shown how to do

Just my 5 cents

best regards

Kim Madsen

--- In, Tim Uckun <tim@d...> wrote:
> >Why not use a function like:
> >
> >select field1,field2,ucase(field3) from atable
> >where ucase(field2)='ABC'
> >order by ucase(field1)
> I have an access database with over 1400 saved queries in it. I
> really, really don't want to go back and redo every single one of