Background : SQL2000 supports collation at different levels. Collation can be based on the Windows Collation or SQL Collation. Collation can be specified at the server, database & column level. For more details, see the BOL topics on COLLATION. So this small article should give a fairly detailed view of the various options available & gotchas! COLLATION is very powerful but requires good understanding to use them efficiently. */