SOUNDEX

[Ruslan Zasukhin]

On 7/27/04 9:20 AM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> 
>> 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)

This will be SCAN, Oliver.


Your idea to pre-calculate and STORE into table code,
Will speed up you.

This is general TIP: precalculation.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------