In the following SQL2000 statement:

Select Id, Name, dbo.MyFunction(Id) as MyFunctionAlias
From MyTable
Where dbo.MyFunction(Id) <> 0

is the function run twice for every record, or is SQL2000 smart enough to
only run it once?

Steve

Not sure Steve, but you could test it very quickly.

Add the function, then put this query into the Query Analyzer and take a
look at the Estimated Execution plan.  It will tell you very quickly whether
or not it is run twice.