tommyh (11/16/2010)

---

Carlo Romagnano (11/16/2010)

---

I should remember implicit cast using CASE clause.

Good question. I refreshed implicit cast.

In sql2000, it gives error also with SET @sortby='Date1'. (Syntax error converting datetime from character string.), not in sql2005.

No it doesnt 🙂 Well its not related to it being SQL2000. Probably some language issue. Works fine on mine.

/T