How to do a case sensitive search in WHERE clause (I’m using SQL Server)?

by

Can be done via changing the Collation. By default it is case insensitive.

Excerpt from the link:

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

Or, change the columns to be case sensitive.

More Related Contents:

  1. Sql Mathematical calculations [closed]
  2. I need help formatting inner join command in SQL query
  3. How to display data in JOIN, and return null value? [closed]
  4. How to deal with SQL column names that look like SQL keywords?
  5. SQL transpose full table
  6. Truncate (not round) decimal places in SQL Server
  7. How to return multiple values in one column (T-SQL)?
  8. Copy data into another table
  9. How to replace a string in a SQL Server Table Column
  10. How to run a stored procedure in sql server every hour?
  11. How do I see active SQL Server connections?
  12. SQL Server LIKE containing bracket characters
  13. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  14. How to run a stored procedure every day in SQL Server Express Edition?
  15. How to copy a huge table data into another table in SQL Server
  16. Alternate of lead lag function in SQL Server 2008
  17. Calculate the number of records for each date between 2 dates
  18. “Order By” using a parameter for the column name
  19. T-SQL: How to use parameters in dynamic SQL?
  20. DISTINCT for only one column
  21. How to compare datetime with only date in SQL Server
  22. SQL server select distinct rows using most recent value only
  23. Split words with a capital letter in sql
  24. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  25. Generate random int value from 3 to 6
  26. What is the internal representation of datetime in sql server?
  27. Eliminate and reduce overlapping date ranges
  28. scope_identity vs ident_current
  29. Cumulative Total in MS Sql server [duplicate]
  30. Export table data from one SQL Server to another

Leave a Comment