SOUNDEX

[erne]

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.
-- 
| e r |  Ernesto Giannotta
| n e |  Musical Box - a media store