At 06:10 AM 27/10/2007, you wrote:

>can you pass me along a sample ALTER
>TABLE with an ADD ... COMPUTED BY ... so that i can see the syntax. i
>tried a few variations but no luck.

alter table master
add summarytotal computed by
(
(select sum(linetotal) from child
where child.masterid = master.masterid)
)

./heLen