Details
-
Improvement
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
0.1.0-m1
-
None
-
every environment
Description
Hi,
would be great to have a ISNUMERIC function in SQL because if you want to run a count on self-described data there should be an option to check wether the field is numeric and therefore countable.
if you have a CSV for example and the first line or some other lines (such as in a pagebreak when importing) include the fieldnames and therefore text-characters.
Would be great if a query such as: SELECT count(columns[0]) as number FROM dfs.`bla` WHERE ISNUMERIC(columns[0])=1
Thanks