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