@Jacob - Your example with LEN is not a good one. The issue there is that the result of the concatenation (@s1 + @s2) doesn't get automatically cast to varchar(max). Nothing to do with the LEN function....

@Jacob - Your example with LEN is not a good one. The issue there is that the result of the concatenation (@s1 + @s2) doesn't get automatically cast to varchar(max). Nothing to do with the LEN function....

@Jacob - Your example with LEN is not a good one. The issue there is that the result of the concatenation (@s1 + @s2) doesn't get automatically cast to varchar(max). Nothing to do with the LEN function....

I've not installed Denali yet. Is there any support for running totals with the OVER clause yet? It didn't seem like it from reading Books On Line....

I've not installed Denali yet. Is there any support for running totals with the OVER clause yet? It didn't seem like it from reading Books On Line....