meta data for this page
  •  

F_GSOUNDEX

function from adhoc

Entrypoint gsoundex not compatible with UTF-8 - if needed please ask

Inputs/Outputs

 Input      CSTRING(8190)      String
 Output     CSTRING(8190)      (german) soundex of string

Syntax

 Determines the german-phonetic string of parameter 1. Could be used e.g. for the doublet search.
 TestSQL
 SELECT 'MAYR' AS ISCORRECT, F_GSOUNDEX('Meier'), F_GSOUNDEX('Maier'), F_GSOUNDEX('Mayer') 
 FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT, F_GSOUNDEX(NULL), F_GSOUNDEX(NULL), F_GSOUNDEX(NULL) 
 FROM RDB$DATABASE;