I Really wonder when i could use this.

Would a indexed UDF really be faster than a join.....

( I tested it and it isn't )

Furthermore is a UDF the right way for the second example.

Although it is a deterministic function a query on the integer

500 would be faster than a query on the string '000500'

so i really wonder if it is really that usefull.

( I liked the Examples don''t get me wrong but i am not that fond

of a UDF because the profiler and the Query Execution Plan

hide the underlying queries. kind of a black box)