Search values ignoring accentuation in SQL Server
Usefull in languages like Brazilian Portuguese pt-BR
select *
from table
where table.field like '%searchValue%' collate Latin1_General_CI_AI
Written by Ion D. Filho
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Search
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#