This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The AnsiPaddingStatus property returns TRUE if the referenced column is defined to exhibit SQL-92 character padding behavior.
An expression that evaluates to an object in the Applies To list
HRESULT GetAnsiPaddingStatus(LPBOOL pRetVal);
By default, Microsoft SQL Server trims trailing blanks, or null bytes, from variable-length character or binary column data when values are inserted. The SQL-92 standard requires trailing blanks and null bytes are not trimmed as data is inserted.