Preface
Function reference
- Function components
Constants
Operators
Dates
Functions
- Function overview
  - Aggregate functions
    - Filter conditions
  - Conversion functions
  - Data cleansing functions
  - Date functions
  - Encoding functions
  - Financial functions
  - Horizontal expansion functions
  - Numeric functions
  - Scientific functions
  - Special functions
  - String functions
  - Test functions
  - Window functions
    - Aggregate functions as window functions
    - Nested aggregate functions as window functions
- Function quick reference
- Functions in advanced mode
- %OPR_CONCAT%
- %OPR_CONCATDELIM%
- %OPR_IIF%
- %OPR_SUM%
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- AES_GCM_DECRYPT
- AES_GCM_ENCRYPT
- ASCII
- AVG
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COMPRESS
- CONCAT
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DECODE
- DECOMPRESS
- ENC_BASE64
- ERROR
- EXP
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- IS_DATE
- IS_NUMBER
- IS_SPACES
- ISNULL
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SET_DATE_PART
- SETCOUNTVARIABLE
- SETMAXVARIABLE
- SETMINVARIABLE
- SETVARIABLE
  - Differences between SETVARIABLE, SETMAXVARIABLE, and SETMINVARIABLE
- SHA256
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- STDDEV
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_FLOAT
- TO_INTEGER
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- UUID_STRING
- VARIANCE
System variables
Datatype reference

Function Reference

Back Next

METAPHONE

Encodes string values. You can specify the length of the string that you want to encode.

METAPHONE encodes characters of the English language alphabet (A-Z). It encodes both uppercase and lowercase letters in uppercase.

METAPHONE encodes characters according to the following list of rules:

Skips vowels (A, E, I, O, and U) unless one of them is the first character of the input string. METAPHONE(‘CAR’) returns ‘KR’ and METAPHONE(‘AAR’) returns ‘AR’.

Uses special encoding guidelines.

The following table lists the METAPHONE encoding guidelines:

Input	Returns	Condition	Example
B	n/a	When it follows M.	METAPHONE (‘Lamb’) returns LM.
B	In all other cases.	METAPHONE (‘Box’) returns BKS.
C	X	When followed by IA or H.	METAPHONE (‘Facial’) returns FXL.
S	When followed by I, E, or Y.	METAPHONE (‘Fence’) returns FNS.
n/a	When it follows S, and is followed by I, E, or Y.	METAPHONE (‘Scene’) returns SN.
K	In all other cases.	METAPHONE (‘Cool’) returns KL.
D	J	When followed by GE, GY, or GI.	METAPHONE (‘Dodge’) returns TJ.
T	In all other cases.	METAPHONE (‘David’) returns TFT.
F	F	In all cases.	METAPHONE (‘FOX’) returns FKS.
G	F	When followed by H and the first character in the input string is not B, D, or H.	METAPHONE (‘Tough’) returns TF.
n/a	When followed by H and the first character in the input string is B, D, or H.	METAPHONE (‘Hugh’) returns HF.
J	When followed by I, E or Y and does not repeat.	METAPHONE (‘Magic’) returns MJK.
K	In all other cases.	METAPHONE(‘GUN’) returns KN.
H	H	When it does not follow C, G, P, S, or T and is followed by A, E, I, or U.	METAPHONE (‘DHAT’) returns THT.
n/a	In all other cases.	METAPHONE (‘Chain’) returns XN.
J	J	In all cases.	METAPHONE (‘Jen’) returns JN.
K	n/a	When it follows C.	METAPHONE (‘Ckim’) returns KM.
K	In all other cases.	METAPHONE (’Kim’) returns KM.
L	L	In all cases.	METAPHONE (‘Laura’) returns LR.
M	M	In all cases.	METAPHONE (‘Maggi’) returns MK.
N	N	In all cases.	METAPHONE (‘Nancy’) returns NNS.
P	F	When followed by H.	METAPHONE (‘Phone’) returns FN.
P	In all other cases.	METAPHONE (‘Pip’) returns PP.
Q	K	In all cases.	METAPHONE (‘Queen’) returns KN.
R	R	In all cases.	METAPHONE (‘Ray’) returns R.
S	X	When followed by H, IO, IA, or CHW.	METAPHONE (‘Cash’) returns KX.
S	In all other cases.	METAPHONE (‘Sing’) returns SNK.
T	X	When followed by IA or IO.	METAPHONE (‘Patio’) returns PX.
0 *	When followed by H.	METAPHONE (‘Thor’) returns 0R.
n/a	When followed by CH.	METAPHONE (‘Glitch’) returns KLTX.
T	In all other cases.	METAPHINE (‘Tim’) returns TM.
V	F	In all cases.	METAPHONE (‘Vin’) returns FN.
W	W	When followed by A, E, I, O, or U.	METAPHONE (‘Wang’) returns WNK.
n/a	In all other cases.	METAPHONE (‘When’) returns HN.
X	KS	In all cases.	METAPHONE (‘Six’) returns SKS.
Y	Y	When followed by A, E, I, O, or U.	METAPHONE (‘Yang’) returns YNK.
n/a	In all other cases.	METAPHONE (‘Bobby’) returns BB.
Z	S	In all cases.	METAPHONE (‘Zack’) returns SK.
* The integer 0.

Skips the initial character and encodes the remaining string if the first two characters of the input string have one of the following values:

KN.
For example, METAPHONE(‘KNOT’) returns ‘NT’.

GN.
For example, METAPHONE(‘GNOB’) returns ‘NB’.

PN.
For example, METAPHONE(‘PNRX’) returns ‘NRKS’.

AE.
For example, METAPHONE(‘AERL’) returns ‘ERL’.

If a character other than “C” occurs more than once in the input string, encodes the first occurrence only. For example, METAPHONE(‘BBOX’) returns ‘BKS’ and METAPHONE(‘CCOX’) returns ‘KKKS’.

Syntax

METAPHONE( string [,length] )

Argument	Required/ Optional	Description
string	Required	Must be a character string. Passes the value you want to encode. The first character must be a character in the English language alphabet (A-Z). You can enter any valid expression. Skips any non-alphabetic character in string .
length	Optional	Must be an integer greater than 0. Specifies the number of characters in string that you want to encode. You can enter any valid expression. When length is 0 or a value greater than the length of string , encodes the entire input string. Default is 0.