Last Updated: February 25, 2016
·
779
· iondrimba

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