Re: handling errors with number conversion

[Barry Galbraith]

Does this help? Convert strings to numbers by adding 0.

mysql> select '+1' + 0;
+----------+
| '+1' + 0 |
+----------+
|        1 |
+----------+
1 row in set (0.00 sec)

mysql> select '-10.00' + 0;
+--------------+
| '-10.00' + 0 |
+--------------+
|          -10 |
+--------------+
1 row in set (0.00 sec)

mysql> select 'english' + 0;
+---------------+
| 'english' + 0 |
+---------------+
|             0 |
+---------------+
1 row in set, 1 warning (0.00 sec)

mysql>

Good luck,
Barry.