Hello,
Suppose that you have a table T1 with columns C11, C12....
When a new line is inserted, I would like modify the value of the field C11 if a given condition is satisfied : If C11 like '-%',
I would like to add 'P' in the bgining of the C11 field :
concat('P', OLD_C11_VALUE).

Can I do that with a trigger and How ?

Thanks a lot in advance.

Sofiane