Thanks to all I found the problem,

in sql 2000 numeric values are not implicitly converted to characters within a string concatenation statment

group by year quarter

quote:

---

Have you looked at the new freeware tool Lumigent released?

Andy

http://www.sqlservercentral.com/columnists/awarren/

---

Its not working for...