Issues with case and collation when my SQL Server database is set to Latin1_General_100_CI_AI?

Try casting one of the fields into the other field's collation.

Try casting one of the fields into the other field's collation: SELECT * FROM as_table JOIN ai_table ON ai_field = as_field COLLATE Latin1_General_100_CI_AI or SELECT * FROM ai_table JOIN as_table ON as_field = ai_field COLLATE Latin1_General_100_CI_AS Note that casting a field makes the predicate unsargable against the index on this field.

Once you've already created objects inside the database, simply changing the collation doesn't change the existing objects. You can see this by right-clicking the tables and scripting them out - they'll have lots of notes about the collations of the varchar fields. If you want the objects to change, you'll need to recreate them.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.