Check a text is number in Snowflake

To Nha Notes | Nov. 24, 2022, 3:45 p.m.

SELECT
    'ABC' AS TXT
,   '123' AS NUM
,   NVL2(TRY_TO_NUMERIC(TXT), 'TXT IS NUMBER', 'TXT IS TEXT') AS TXT_TYPE
,   NVL2(TRY_TO_NUMERIC(NUM), 'NUM IS NUMBER', 'NUM IS TEXT') AS NUM_TYPE

 

Expected results:

TXT NUM TXT_TYPE NUM_TYPE
ABC 123 TXT IS TEXT NUM IS NUMBER

 

Posts
Technical AI Startup Work Learning Tools Books Kinh doanh Đọc sách Làm bánh Cuộc sống Tài chính Bất động sản Đầu tư Thuế Nice words