Hi,

> Can I make a index on two fields in a table, where the condition is
> something like this:
>
> create index MyIdx
> on MyTable (((MyField1*100)+MyField2));

No.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com