Answers for "how to do a case sensitive search in sql"

1

sql like case sensitive

-- Postgresql case insensitive:
SELECT * FROM people WHERE name ILIKE 'JOHN'
-- John
-- JOHN
-- john
Posted by: Guest on April-05-2021
0

sql server case sensitive search

SELECT 1
FROM dbo.Customers
WHERE   CustID = @CustID COLLATE SQL_Latin1_General_CP1_CS_AS
    AND CustPassword = @CustPassword COLLATE SQL_Latin1_General_CP1_CS_AS
Posted by: Guest on February-05-2021

Browse Popular Code Answers by Language