CHCKNUM_UDF
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Definition
Check if a string value represents a numeric value.
PUBLIC.CHKNUM_UDF(NUM STRING);
Parameters
NUM
STRING
The value of the string to be checked.
Returns
Returns 1 if the parameter is a valid number. Otherwise, returns 0.
Example
Input:
SELECT CHKNUM('1032');
Output:
SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'CHKNUM_UDF' INSERTED. **
PUBLIC.CHKNUM_UDF('1032');
Last updated