Case-Sensitive Search Function in SQL

The function that retrieves records based on a case-sensitive search in SQL is 'Binary'.

Explanation:

The 'Binary' operator is used in conjunction with the 'LIKE' operator to perform case-sensitive searches. It forces the comparison to be made literally, considering the case of each character.

Example:

SELECT * FROM Customers WHERE CustomerName LIKE 'Binary' 'John';

This query will only return records where the 'CustomerName' column contains the exact string 'John' with a capital 'J'.

Other Options:

• like: The 'LIKE' operator itself is not case-sensitive by default. It performs pattern matching, ignoring case unless used with the 'Binary' operator.
• cast: The 'CAST' function converts data types, not affecting search sensitivity.
• convert: The 'CONVERT' function also converts data types, not changing search sensitivity.