SQLite Forum

Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings)

I use the `ABS()` function.  It will return zero on anything non-numeric.
The only caveat is zero.

Check like:

`iif(abs(field) > 0 or field = 0,...,...)`