Subject | Re: [IB-Architect] Syntax for case insensitive sort |
---|---|
Author | Tim Uckun |
Post date | 2000-03-29T18:09:28Z |
>Why not use a function like:I have an access database with over 1400 saved queries in it. I really,
>
>select field1,field2,ucase(field3) from atable
>where ucase(field2)='ABC'
>order by ucase(field1)
really, really don't want to go back and redo every single one of them.