SQL Case Sensitive String Compare

by 
Select * from a_table where attribute="k" COLLATE Latin1_General_CS_AS

Did the trick.

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  3. Should I use != or for not equal in T-SQL?
  4. Conversion failed when converting date and/or time from character string while inserting datetime
  5. Create a date from day month and year with T-SQL
  6. Foreign Key to non-primary key
  7. How should I pass a table name into a stored proc?
  8. Difference between left join and right join in SQL Server [duplicate]
  9. SQL Server – How to lock a table until a stored procedure finishes
  10. Where value in column containing comma delimited values
  11. How to use table variable in a dynamic sql statement?
  12. How to create a unique index on a NULL column?
  13. Search text in stored procedure in SQL Server
  14. Difference between datetime and timestamp in sqlserver? [duplicate]
  15. Sequence vs identity
  16. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  17. “IN” clause limitation in Sql Server
  18. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  19. Reference an alias elsewhere in the SELECT list
  20. Selecting first row per group
  21. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  22. SQL Server Convert integer to binary string
  23. How to find column names for all tables in all databases in SQL Server
  24. SQL Row_Number() function in Where Clause
  25. SQL update trigger only when column is modified
  26. Backup a single table with its data from a database in sql server 2008
  27. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  28. Try_Convert for SQL Server 2008 R2
  29. SQL Server variable scope in a stored procedure
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment