Case Sensitive comparison of data in Select query





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)




Tags:

Comments are closed.