#47 Simple T-SQL UDF Providing Leading Zeroes
This is simply a conversion of this post to an UDF that provides leading zero support on an int field & returns a varchar(20).
Create FUNCTION [dbo].[udf_LeadingZeroes]
(
@FieldValue int
, @LeadZeroCount int
)
RETURNS varchar(20) AS
BEGIN
Declare @ReturnString varchar(20)
Set @ReturnString = RIGHT(REPLICATE('0', @LeadZeroCount) + CONVERT(varchar(20), @FieldValue), @LeadZeroCount)
RETURN @ReturnString
END
-- Usage
Select dbo.udf_LeadingZeroes(ColName,4) as ColName_With_LeadingZeroes
From SomeTable
Advertisement
