>>>Hi,
>>>
>>>I have a program using some VFP 2.6 tables to maintain compatiblility with Clipper. I need to use a UDF to do indexing to get the right collation. In the progress to move to .Net I need the same user defined function in VFPOLEDB. Is it possible? (Index on UDF(string))
>>>
>>>Einar
>>
>>If you will move to .Net(VB or C#) forget for DBFs. Look for other DB - JetEngine, SQLServer(or its cut version MSDE), MySQL, etc.
>
>It is not a question about selecting another DB. (We are working mostly with SQL server.) But I still need to maintain old systems. Is it possibly to create an index on a function using ADO.NET?

Do it with VFP.
We had order from P&G UK to move their old FP2.6 PO system to VB.Net but to keep DBFs, because some of other modules still work with them. We have a lot of problems during development and after that. In the end they agreed we to move everything in .Net and to change DB
What you will do is your own problem. Just friendly advice. MS .Net advertising push many people to make stupid decisions moving their Foxpro systems to .Net