Subject Re: [ib-support] ignore case order by
Author Joe Martinez
I don't believe there's a particular way to tell FB to do a case insensive
order by, but here's what I do:

Let's say I want to bring up a list of cities from my cities table. I'll do
something like:

select upper(city) from cities
order by 1

If you want to preserve the original capitalization in your results, you can
select the non-upper'ed version as well like:

select upper(city),city from cities
order by 1

And then just use the second column for your purposes.


Massimo Ferrari wrote:

> Hello,
> how can I tell Firebird via SQL to perform an ignore case order by?
> thank you
> Massimo