Tips for Querying Special Characters with wildcards, since some symbols are tricky to pattern match. Examples use the [Grant] table in the JProCo database.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.