Trigger return value

I have a trigger which sets a field value prior to insert and I want to
know what that value is. Is it possible to return this value from the
trigger so that it appears in the resultset of the sql command?

Thanks

Brian.