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