DB2- How to check if varchar field value has integers

Question

Is there an inbuilt DB2 function or any query to check if the character i have is a number? (I cannot use user defined functions)

Accepted Answer

Doc Link

```
CASE
  WHEN LENGTH(RTRIM(TRANSLATE(test_str, '*', ' 0123456789'))) = 0 
  THEN 'All digits'
  ELSE 'No'
END
```

Solution