NOW is the old way - the new and preferred way
is to use the SQL92 CURRENT_TIME/DATE/TIMESTAMP
functions.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> here's a line out of a before update trigger
> NEW.LASTUPDATE = 'NOW';
> that what you need?