How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
Posted
by ilivewithian
on Stack Overflow
See other posts from Stack Overflow
or by ilivewithian
Published on 2010-03-17T10:41:15Z
Indexed on
2010/03/17
10:51 UTC
Read the original article
Hit count: 183
Filed under:
sql-server-2005
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?
© Stack Overflow or respective owner
