Ansi SQL type casting

ansi-sql, casting, sql

Solution

The `CAST` expression was added in SQL-92. You can see it for example in this draft.

Problem

Is it allowed to cast types in ANSI SQL like in postgres for example: ``` SELECT SUM( CAST(qnty AS int) - CAST(reserve AS int) ) AS sum ... ``` qnty and reserve are character columns.

Original source