Hi

If I read the documentation correctly I should be able to create an index on an expression using Alter Table but when I try the following command I get a syntax error. Can someone tell me what is wrong or whether this is possible? I have tried a number of variations without success.

      Alter Table UPSystem Add Foreign Key Upper(Module+Name) Tag Name

Thanks,
Simon