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.

See Also