>>From what I can tell, it's not possible to create SQL server indexes which include UDFs. Is this correct?
>>
>>i.e. in VFP you could say
>>INDEX ON MyFunction(SomeDataField) TAG MyTagName

>Not in SQL Server 7. I believe SQL Server 2000 allows you to define functions >so you may be able to do it then.

After further research, it appears you cannot. The CREATE INDEX command syntax in 2000 still requires column names, and not an expression.

Thanks