TRY_CAST

1
SELECT
2
  TRY_CAST('123' AS INTEGER) AS valid,
3
  TRY_CAST('abc' AS INTEGER) AS invalid;

1
SELECT
2
  raw_value,
3
  TRY_CAST(raw_value AS DOUBLE) AS clean_value
4
FROM raw_data
5
WHERE TRY_CAST(raw_value AS DOUBLE) IS NOT NULL;

1
SELECT
2
  COALESCE(TRY_CAST(input AS INTEGER), 0) AS safe_int
3
FROM user_input;

1
SELECT
2
  COUNT(*) AS total_rows,
3
  COUNT(TRY_CAST(date_field AS DATE)) AS valid_dates,
4
  COUNT(*) - COUNT(TRY_CAST(date_field AS DATE)) AS invalid_dates
5
FROM imported_data;