SQLite Forum

Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings)
Login
Unfortunately it looks like `abs()` gets confused by strings that start with an integer but then contain non-integer text:

`select abs('101'), abs('3.2'), abs('dog'), abs('1 dog');`

Returns:

abs('101') | abs('3.2') | abs('dog') | abs('1 dog')
- | - | - | -
101.0 | 3.2 | 0.0 | 1.0

<https://latest.datasette.io/fixtures?sql=select+abs%28%27101%27%29%2C+abs%28%273.2%27%29%2C+abs%28%27dog%27%29%2C+abs%28%271+dog%27%29%3B>