create table #tmp_int
(
field int null
)

insert into #tmp_int values (23)
insert into #tmp_int values (27)
insert into #tmp_int values (3467)
insert into #tmp_int values (321)
insert into #tmp_int values (-23)
insert into #tmp_int values (null)

create table #tmp_varchar
(
field varchar(11)
)

Insert Into #tmp_varchar
Select
CASE SIGN(field) WHEN -1 THEN '-' ELSE ' ' END+REPLICATE('0',10-LEN(CAST(ABS(field) As varchar(10))))+CAST(ABS(field) As varchar(10))
From
#tmp_int

Select * from #tmp_int
Select * from #tmp_varchar

drop table #tmp_int
drop table #tmp_varchar