Using Computed fields in triggers


I want to use the FB2 feature alowing use of expressions in indexes,
so
that all my indexes are upper case.

I can do this for single-field indexes, e.g.

CREATE INDEX IX01 ON TABLE1 COMPUTED BY (UPPER(FIELD1));

but I can't find the right syntax for an index with two or more
fields.

If I use ||, presumably the trailing spaces on the first field will be
trimmed, and results will be incorrect. e.g. AAA,BBB should come
before AAAA, BBB, but AAABBB will come after AAAABBB.

What is the correct syntax for this?

Roger Vellacott
Passfield Data Systems Ltd