I have a report that goes and does a sort of field validation/quality assurance check.<BR><BR>Basically it runs a bunch of sub queries and shows a summary report.<BR ...

Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. This SQL Server tip illustrates how you can force the use of any specific collation. Collation ...