>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao