Re: Why does this not work?

----- Original Message -----
From: "Johann Zuschlag"

>
> Is there a solution for such a problem?
> Let's assume you can't be sure whether you get
> the appropriate length in an insert.
>

what about changing the column from varchar to text?

size shouldn't be an issue and your trigger will be able to cut the content
to the desired length


hth,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "