I'm working at a web site search which uses Sql server 2008 express edition.
I have 'Books' table which has a field named 'Title' where there are titles containing romanian (latin) characters.
Well, if the user inserts a word like: 'casa' in the search field and i have a title in db like: 'test casă test' i want to show that book but:
select * from books where title like '%casa%'
will not find it...
Do you know any function which removes the diacritics when doing the select?
I know that i can solve the problem with full text searching add-on of sql server but i want to do it in a simpler way.