Trigger script

[cybertrippin]

How do i in an insert trigger (before) reference a field and change its value.

Table x(
x varchar(10)
)

trigger x_x on ... for insert as ....
begin
set new.x = 'My new value'
end


Thanx.