Search for words with the letter ü in MS SQL

Question

When I do a LIKE search in MS SQL I want to get all Günter's when I search for Gunter. I'm using the Finnish_Swedish collation and they treat them as different characters. Anyone have a tip?

Answer 1

You can use the following query

SELECT * FROM mytable WHERE Column LIKE '%G[uü]nter%'

That will search for one of the 2 versions of u

Answer 2

It seems you specified an accent sensitive collation for your server or database.
To do an accent insensitive select, you can explicitly specify a collation.
However, it seems you have chosen the wrong collation for your purpose.