DIFFERENCE

DIFFERENCE(X, Y)

Parameters

• X, Y - strings to compare.

Description

Returns the difference between the sounds of two strings. This method returns an int.

Example

Calculates a harmony for Players' names:

select DIFFERENCE(T1.NAME, T2.NAME) FROM players T1, players T2
   WHERE T1.ID = 10 AND T2.ID = 11;