> > What syntax Is used in SQL Server ? > SQL Server : The function SOUNDEX () return the basic code of Soundex. eg To search persons whose name has the same consonance as a typed name we can, for example, use the following code SQL: Select * from T_PERSONNE Where SOUNDEX(:The Name) = SOUNDEX(T_PERSONNE.NOM_PERS) olivier