----- 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. "