SOUNDEX

Robert Brenstein rjb at rz.uni-potsdam.de
Tue Jul 27 12:00:55 CDT 2004


>Hi Ruslan,
>
>on 27-07-2004 10:21, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:
>
>>>  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.
>>
>
>please include this Soundex() function in your methods library
>so we can create indexed method fields like in
>f.SetMethod('Soundex(namefield)')
>
>
>Cool Runnings,
>Erne.

yes. and plan an option to specify language.


More information about the Valentina mailing list