> INSERT INTO WHATEVER (NUMBER, USER)
> SELECT (COALESCE(MAX(NUMBER), 0) + 1) AS NUMBER,
> "a name" AS USER FROM WHATEVER

Hey Arno, you do know that this will only work if you
have a table named "WHATEVER", right?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com