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
it.

Just my 5 cents

best regards

Kim Madsen
kbm@...

--- In IB-Architect@onelist.com, 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, really don't want to go back and redo every single one of
them.