create function TRIM(@s varchar(max)) returns varchar(max) as
begin
declare @r varchar(max)
declare @i integer
declare @l integer
set @l = len(@s)
if @l < 1
set @r = ''
else begin
set @i = 1
while ascii(substring(@s, @i, 1)) <= 32 set @i = @i + 1
while ascii(substring(@s, @l, 1)) <= 32 set @l = @l - 1
set @r = substring(@s, @i, @l-@i+1)
end
return @r
end

李战(leadzen)