How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?

by

Coerce to an accent insensitive collation

You’ll also need to ensure both side have the same collation to avoid errors or further coercions if you want to compare against a table variable or temp table varchar column

and because the constant value will have the collation of the database Update: only for local variables, not for constants nope, not even then

SELECT *
FROM Venue
WHERE
   Name COLLATE Latin1_general_CI_AI Like '%cafe%' COLLATE Latin1_general_CI_AI

More Related Contents:

  1. Retrieving last record in each group from database – SQL Server 2005/2008
  2. Base64 encoding in SQL Server 2005 T-SQL
  3. Calculating timespan with t-sql
  4. Isoweek in SQL Server 2005
  5. Aggregate SQL Function to grab only the first from each group
  6. How can I do an UPDATE statement with JOIN in SQL Server?
  7. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  8. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  9. Parameter Sniffing (or Spoofing) in SQL Server
  10. SQL Server String or binary data would be truncated
  11. How to change identity column values programmatically?
  12. SQL Server : Transpose rows to columns
  13. What represents a double in sql server?
  14. SQL query to find Missing sequence numbers
  15. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  16. WHERE clause on SQL Server “Text” data type
  17. How to split string using delimiter char using T-SQL?
  18. How to update data in one table from corresponding data in another table in SQL Server 2005
  19. SQL server select distinct rows using most recent value only
  20. What good are SQL Server schemas?
  21. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  22. Problem with Renaming a Column in SQL Server
  23. Eliminate and reduce overlapping date ranges
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. Cumulative Total in MS Sql server [duplicate]
  26. How to parse string into date?
  27. @@ERROR and/or TRY – CATCH
  28. Distributed transaction error?
  29. How do you store a picture in an image column?
  30. Determine what user created objects in SQL Server

Leave a Comment