jdmartin74
Programmer
I wonder if anyone has crossed this and has an answer...
I have a query which is doing to_number(field) on one of the columns. My problem is this data (users being users) has some mis-typed values. e.g. '1.r' instead of '1.4'. Obviously, when the query runs, it gets an invalid number.
Is there a function is in Javascript such as isNaN to check if a value is a number of not? I realise I could write a function, but would like to do this in the SQL itself.
Thanks.
J.
I have a query which is doing to_number(field) on one of the columns. My problem is this data (users being users) has some mis-typed values. e.g. '1.r' instead of '1.4'. Obviously, when the query runs, it gets an invalid number.
Is there a function is in Javascript such as isNaN to check if a value is a number of not? I realise I could write a function, but would like to do this in the SQL itself.
Thanks.
J.