Hi,

With this T-SQL command i can read ANSI_PADDING property of a varchar field:

SELECT COLUMNPROPERTY( OBJECT_ID('myTable'),'myVarCharColumn','UsesAnsiTrim')

But if i want change it, i can do the operation with a sigle T-SQL command ?

Note: SET ANSI_PADDING use Padding on command, but use Trim for property.
In-fact it is a Trim function.
SET ANSI_TRIM (exchanging ON/OFF) is more clear for me.

Fabio