What I would like to do:
string strConstant = "This is the beginning"
When a record is inserted, I want to immediately grab the value of a ntext field and append it to the strConstant variable and then update the ntext field with the vaule of the strConstant.
I have no experience with triggers and was hoping for some direction. Should I use an after insert?
can some one give me a little snippet?