Re: Ignore accents using the LIKE Operator...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 16:15:45 +0100

In SQL Server 2000, you could specify an accent insensitive collation for
your LIKE query, for example:

SELECT * FROM Table WHERE nom LIKE '%Belanger%' COLLATE
SQL_Latin1_General_CP1_CI_AI 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"+The_Taco+" <dominic.feron@dessausoprin.com> wrote in message
news:eHABwSjeEHA.724@TK2MSFTNGP10.phx.gbl...
Is it possible?
Here's an example:
SELECT * FROM Table WHERE nom LIKE '%Belanger%'
I got two type of Belanger in my table, one with an accent ('Bélanger'), the
other, no accent ('Belanger'). Right now, it only returns me 'Belanger' with
no accent...
Is there any way I can ignore the accent using the LIKE operator?
Thanks for the help!

Relevant Pages

  • Re: Phonetic Full Text Search
    ... accent insensitive FT search an still be done with SQL Server ... >> that will expand the search terms for accented versions of the term or ... >> expand for diacritics. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Query using only ASCI characters
    ... Jet is case insensitive but accent sensitive. ... MS SQL Server can have ... column, or a table, of aliases. ... > The purpose of that is to avoid replica of data, in case that a user has ...
    (microsoft.public.access.formscoding)
  • Re: Different result when using Indexing Service Query Form and SQL Server
    ... By default IIRC SQL Server 2005 is accent insensitive whereas indexing ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... When I use the "Indexing Service Query Form", ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Collation Sequences, Accented Characters and ORDER BY clauses
    ... Many thanks for the reply - at least that explains what SQL Server is doing. ... Mark ... > In SQL's accent sensitive collations, the presence or absence of accented ...
    (microsoft.public.sqlserver.odbc)
  • Re: FTS is accent sensitive?
    ... The answer to your question for SQL Server 2000 is no. ... I've tested this with both an accent sensitive database and an accent ... select TextCol, VarcharCol, CharCol from FTSAccent ...
    (microsoft.public.sqlserver.fulltext)