Are types allowed in ANSI SQL, for example in postgres:
SELECT SUM( CAST(qnty AS int) - CAST(reserve AS int) ) AS sum ...
qnty and character columns are reserved.
In SQL-92, a CAST expression has been added. You can see this, for example, in a draft .
CAST