Dear Roger,

Please refer to the example in SET ANSI_PADDING (Transact-SQL),

http://msdn.microsoft.com/en-us/library/ms187403.aspx

Hope it is useful.

Best Regards, Yong Seng