But you can create one with SQL Server 2000


CREATE FUNCTION PadWithZeros (@value INTEGER, @len INTEGER)
RETURNS CHAR(5)
AS
BEGIN
RETURN right(REPLICATE('0', @len)+ltrim(str(@value)), @len)
END

Or something like that.

-Mike