SET ANSI_PADDING#
Controls the way the column stores values shorter than the defined size of the column, and the way the column stores values that have trailing blanks in char, varchar, binary, and varbinary data.
Syntax#
SET ANSI_PADDING { ON | OFF } [;]
Remarks#
Argument values are ignored and do not change the default behavior.
Permissions#
Requires membership in the public role.