--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> OK, that's easy. Create three (or N) other fields, populate them
> with triggers that chop the main field into three (or N) pieces
> and index the pieces. Your queries will be
>
> select whole_field from table order by sub1, sub2, sub3
>
>

Excellent, I'll try that today.