Numeric value 'xyz' is not recognized. How to fix the Snowflake Error message

While executing a sql query in Snowflake, you often stumble upon this error:

Numeric value 'xyz' is not recognized

It simply means, 

• You have a varchar column that you are trying to compare with a numeric value
• Or, Trying to cast a varchar to number, but the column has characters

For example:

select * from customer_address WHERE address_ind = 1;

Convert it to :

select * from customer_address WHERE try_to_number(address_ind) = 1;

This will try to convert the column first to number and if there are any unsupported columns, it will use NULL for them

nVector

posted on 29 Oct 19