At 11:57 AM 12/05/2003 +0000, you wrote:

>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));

Not directly - expression indexes are not possible.

However, you can create an indexed column of the appropriate type and write
a Before Insert and a Before Update trigger to populate it/conditionally
update it with the calculated value.

heLen