Adding Trailing Spaces to a Column

Declare @MaxLengthInColumn

SELECT @MaxLengthInColumn=MAX(len(ColumName) ) from TableName

SELECT ColumnName+space(   @MaxLengthInColumn -  len(ColumName)   ) FROM TableName