How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
- by ilivewithian
I'm looking to compare two varchars in SQL, one would be something like Cafe and the other Café is there a way in SQL that will allow the two values to be compared. For instance:
SELECT *
FROM Venue
WHERE Name Like '%cafe%'
So if there is a venue with the name Big Bobs Café Extraordinaire it would be included in the result set?