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.
Simon White
dCipher Computing