DIFFERENCE

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• SQL Server

• Azure Synapse Analytics

Description

Returns an integer measuring the difference between two strings using the SOUNDEX algorithm (DIFFERENCE in Transact-SQL). It counts the common characters of the strings resulting by executing the SOUNDEX algorithm.

Sample Source Pattern

Syntax

DIFFERENCE( expression1, expression1 )

Arguments

expression1, expression2: String expressions to be compared.

Return Type

Int.

Examples

Query

SELECT DIFFERENCE('Like', 'Mike');

Result

    Output |
-----------|
         3 |

Known Issues

No issues were found.

Related EWIs

No related EWIs.