Dave Wellman wrote: > Why do I need the "()" around my calculation?
<http://www.sqlite.org/lang_expr.html#castexpr> says: | When casting a TEXT value to INTEGER, the longest possible prefix of | the value that can be interpreted as an integer number is extracted | from the TEXT value and the remainder ignored. Any leading spaces in | the TEXT value when converting from TEXT to INTEGER are ignored. If | there is no prefix that can be interpreted as an integer number, the | result of the conversion is 0. So the result of 'forty-two'+0 is 0. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
