Believe it Seems intuitive, doesn't it? But of course it's not. This is one of the issues fixed in SQL 2005 with the censored. For the example you gave, you could use a VIEW instead ofa UDF. Of course if you want to add additional processing logic that won't work.