>>Just because you can, doesn't mean you should :)
>
>.T. - but personally I have used UDF's in an index expression and not ever had a problem - although not in the way that Wayne was trying it. I think Wayne was perhaps given the impression that its never ok to use a UDF in an index - which it is ... sometimes.
>
Okay, I agree with that :)
>
>>Jim pointed out to him the danger of using the UDF...the index will break when someone changes the name in the related file. So to help him make the UDF "work" would have been bad help, right?
>
>.T. and .F. - Showing how it can be done
and highlighting the danger is the best of both worlds. Wayne can then decide how to take it further for his own particular project.
>
I don't agree with that...since it was clearly related to another table.
>
>Have a good one!
>
You too!
Steve Gibson