SQL server ignore case in a where expression

by

In the default configuration of a SQL Server database, string comparisons are case-insensitive. If your database overrides this setting (through the use of an alternate collation), then you’ll need to specify what sort of collation to use in your query.

SELECT * FROM myTable WHERE myField = 'sOmeVal' COLLATE SQL_Latin1_General_CP1_CI_AS

Note that the collation I provided is just an example (though it will more than likely function just fine for you). A more thorough outline of SQL Server collations can be found here.

More Related Contents:

  1. Conditional WHERE clause in SQL Server
  2. Convert text to system date format [duplicate]
  3. How to get a particular preceding value of a column in SQL [closed]
  4. How to select just the row in the second table?
  5. Need SQL Script
  6. SQL update from one Table to another based on a ID match
  7. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  8. SQL JOIN vs IN performance?
  9. Can a foreign key be NULL and/or duplicate?
  10. sql query to return differences between two tables
  11. How to generate a range of dates in SQL Server
  12. SQL RANK() versus ROW_NUMBER()
  13. Generate SQL Create Scripts for existing tables with Query
  14. SQL Server 2005 How Create a Unique Constraint?
  15. Check if a row exists, otherwise insert
  16. Export SQL query data to Excel
  17. Insert Picture into SQL Server 2005 Image Field using only SQL
  18. Execute Stored Procedure from a Function
  19. SQL SERVER: Get total days between two dates
  20. Alter user defined type in SQL Server
  21. Deferrable Constraints in SQL Server
  22. What does sp_reset_connection do?
  23. SQL Server equivalent to MySQL enum data type?
  24. How do I loop through a set of records in SQL Server?
  25. Create parameterized VIEW in SQL Server 2008
  26. Replace first occurrence of substring in a string in SQL
  27. How to correctly insert newline in nvarchar [duplicate]
  28. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  29. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  30. Convert bigint to datetime

Leave a Comment