Subject Re: [IB-Architect] Syntax for case insensitive sort
Author Tim Uckun
>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.