> >>> I wonder how I'll get a div-function in SQL?
> >> I dunno, maybe by looking in the manual? From :
> >> Division:
> >> mysql> SELECT 3/5;
> >> -> 0.60
> >>  http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
> > Gustav is looking for the DIV-function.
> > But it is there
> > |DIV|
> > Integer division. Similar to |FLOOR()| but safe with |BIGINT| values.
> He never said he wanted integer division... he just said "I want to
> divide t[w]o columns and make a new column based on the result."
Ehm, no. He specifically asked for a DIV function, not a "division". :-)
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!