The only thing I can think of is using a trigger to update that field after insert

update query:

--drop table #t

create table #t (spaces nvarchar(9))

insert into #t

select 'me' union all

select 'you' union all

select 'allofus' union all

select 'they'

update #t

set spaces = right(' '+spaces, 9) from #t

select * from #t