MSCEWI3015

NLSSORT turned to collate function.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

NLSSORT function was converted to COLLATE function. This applies when the NLSSORT function is not in a select body.

Example Code

Input Code:

SELECT name FROM products
WHERE NLSSORT(name, 'NLS_SORT = Spanish') > NLSSORT('Gaberd', 'NLS_SORT = Spanish');

Output Code:

SELECT name FROM PUBLIC.products
WHERE /*** MSC-WARNING - MSCEWI3015 - FUNCTION NLSSORT NLSSORT(name, \'NLS_SORT = Spanish\') TURNED TO COLLATE FUNCTION ***/
 COLLATE(name, 'sp') > /*** MSC-WARNING - MSCEWI3015 - FUNCTION NLSSORT NLSSORT(\'Gaberd\', \'NLS_SORT = Spanish\') TURNED TO COLLATE FUNCTION ***/
 COLLATE('Gaberd', 'sp');

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]