Trigger with case possible?

[erwin traas]

Hello,

I'm rather new to triggers, here is what I want to do 'after update' on a certain table.

I want to check the value of a field like :

progress bigger the 0 but less then 100 -> insert a log into a second table
progress equals 100 -> insert another record into the second table

Can this be done by triggers?

Regards
Erwin