Rob Fitzpatrick
ProgressTalk.com Sponsor
Interesting. I understand that if you did something silly like increment a loop counter and use it in a function in the WHERE clause it would have to be evaluated with every iteration. But a function like I've shown above obviously (to me, anyway) doesn't change its value based on anything the FOR block does. I would have thought the runtime could just evaluate for the first loop iteration and treat it as a constant for the rest.