Formating Data In A Table

Hi

I wanted to knoe if it is possible to remove the leading and trailing spaces by using the RTrim and LTrim?

Currently I have the table Below is it possible to format all the data i.e. remove all leading and trailing spaces in the table from every record?


select *

from
(
select 'Rivet' as [Name], '01' as PartNo, '1999' as Year union all
select 'panel', '041', '1999' union all
select ' side panel', '021', '1999' union all
select 'thread ', '042', '1999'

) t