Yes I can do that.


>>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
>
>Use just the regular INDEX ON command to create an index. You then will be able to turn it into FK using ALTER TABLE command.