Have you ever noticed when you do a string comparison in SQL using '=' notation, case of the string is neglected ???
For example, If TestTable has a TestColumn and it consist of values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records...