meta data for this page
  •  

F_GENERATESNDXINDEX

Compatibility to FreeUDFLib, FreeUDFLib AvERP

F_SOUNDEX

function from adhoc

Entrypoint soundex compatible with UTF-8

Inputs/Outputs

 Input       CSTRING(8190)      String to generate Soundex
 Output      CSTRING(6)         original (american) soundex of string

Syntax

 Soundex is a phonetic algorithm to indexation of words and cliches after its sound in the English language.  Equalequivalent words are to be coded thereby to an identical character sequence. 
 Considered starting from the 2.  place counted only the first 6 consonants with the determination, whereby repeated occurrence is only once considered (in the example the l,m,y,w,r,d).  Therefore it is unsuitable, around longer strings to compare.
 TestSQL
 SELECT 'H4564' AS ISCORRECT, F_GENERATESNDXINDEX('Hello my world') FROM RDB$DATABASE;
 SELECT 'H4564' AS ISCORRECT, F_GENERATESNDXINDEX('Hello my world on my earth') FROM RDB$DATABASE;
 SELECT 'H4564' AS ISCORRECT, F_SOUNDEX('Hello my world') FROM RDB$DATABASE;
 SELECT 'H4564' AS ISCORRECT, F_SOUNDEX('Hello my world on my earth') FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT, F_SOUNDEX(NULL) FROM RDB$DATABASE;