SOUNDEX
Ruslan Zasukhin
sunshine at public.kherson.ua
Tue Jul 27 13:04:21 CDT 2004
On 7/27/04 12:37 PM, "erne" <ernestogiannotta at tiscalinet.it> wrote:
> 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)')
Yes this is possible.
--
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
-------------------------------------------------------------
More information about the Valentina
mailing list