Hi,

> How can I alter the expression of a computed field?
>
> I won't recreate the field because there are a lot of views and
> stored procs depending on it.

You can't.

However, you CAN do this by updating the system tables
directly. Database Workbench ( www.upscene.com ) can
do this for you, simply by editing the COMPUTED BY
expression in the Table Editor.

With regards,

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