alter function dbo.fw (@n int)
returns varchar(10)
as
begin
declare @st1 varchar(10),@st2 varchar(10)
declare @v int
set @st1 = cast(@n as char(10))
set @st2 = ''
set @v = 4 - Len(@st1)
while @v>0
begin
set @st2 = @st2 + '0'
set @v = @v - 1
end
set @st2 = @st2 + @st1
return (@st2)
end
returns varchar(10)
as
begin
declare @st1 varchar(10),@st2 varchar(10)
declare @v int
set @st1 = cast(@n as char(10))
set @st2 = ''
set @v = 4 - Len(@st1)
while @v>0
begin
set @st2 = @st2 + '0'
set @v = @v - 1
end
set @st2 = @st2 + @st1
return (@st2)
end
create function dbo.fw (@n int)
returns varchar(10)
as
begin
Return(replicate('0',4-len(cast(@n as varchar)))+cast(@n as varchar))
end
declare @n int
set @n=20
select left('0000',4-len(@n))+cast(@n as varchar)
------
declare @a char(4),@b char(4)
set @a = 'abc'
set @b = '123'
set @a = @a + @b
print len(@a)declare @a varchar(4),@b varchar(4)
set @a = 'abc'
set @b = '123'
set @a = @a + @b
print len(@a)