Pages

Saturday, September 21, 2013

SQL SERVER – Collate – Case Sensitive SQL Query Search | Journey to SQL Authority with Pinal Dave

Case Sensitive SQL Query Search If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records. SELECT Column1 FROM Table1 WHERE Column1 = 'casesearch' To make the query case sensitive and retrieve only one record (“casesearch”) from above query, the collation of the query needs to… Continue Reading...

Source: SQL SERVER – Collate – Case Sensitive SQL Query Search | Journey to SQL Authority with Pinal Dave