Mark (8/28/2008)

---

As a matter of interest are you based in the UK? What are the regional settings of your SQL 2005 Server? You mentioned it's a collation issue......

I assume it is Windows collation, but I don't see CP1_CI_AS in this list: http://msdn.microsoft.com/en-us/library/ms143515.aspx