Removing white space in Stored procedure output.

Does anyone know how to trim the output of a SQL Stored Procedure which is
of the form 'select * from database' in order to remove trailing white space
in the resulting recordset data?

Regards,

Brendan Daly.