如何修改此SQL SELECT语句以更改非数字值？

SELECT 
    CASE 
        WHEN column_name = '非数字值' THEN '替换值'
        ELSE column_name
    END AS new_column_name
FROM table_name;

SELECT 
    CAST(column_name AS INT) AS new_column_name
FROM table_name;

SELECT 
    CASE 
        WHEN ISNUMERIC(column_name) = 0 THEN '替换值'
        ELSE column_name
    END AS new_column_name
FROM table_name;

SELECT 
    REGEXP_REPLACE(column_name, '[^0-9]', '') AS new_column_name
FROM table_name;