>>Anyway, what in your opinion is better: this UDF or the long complicated expression? (BTW, I already updated our IndxDict with this long expression for all "name" kind of indexes).
>
>Nadya,
>Stored procedures move with thair databases.
>Cetin
Right. However, currently it's not a SP. My DataDict application doesn't have a mechanism for updating stored procedures... I'll check with my manager, what is better in his opinion...
If it's not broken, fix it until it is.
My Blog