I have a state table with primary keys like AK, AL, etc. (state abbreviations) I have another table with a column that references it, but there's entries in the column like Ak, aL, etc. What's up with that? I thought foreign key relationships validated exact matches. Is there a flag or setting in SQL Server to make foreign key relationships case-sensitive?