You can forcefully do the case sensitive comparison of data in sql serer by using COLLATE Latin1_General_CS_AS in a select query
Select * from Table1 inner join Table2 Table2.ID=Table1.ID where
(Table2.WebsiteUrl COLLATE Latin1_General_CS_AS)<>(Table2.websiteurl COLLATE Latin1_General_CS_AS)
