>I need to padlef a string with zeros in TSQL, but I can't find the command.
>42 -> 0042
>
>Any help would be appreciated.
>
>Thanks,
>Einar
For reference, here are TSQL function definitions for PADL and PADR..
_______________________________________________
create function PADL (@pcString varchar(200),@pnLength int,@pcPadChar char(1))
returns varchar(200)
as
BEGIN
declare @ReturnString varchar(200)
if @pcString is NULL
set @pcString = ''
if datalength(@pcString)>@pnLength
set @ReturnString = left(@pcString,@pnLength)
else
set @ReturnString = (SELECT REPLICATE(@pcPadChar, @pnLength - DATALENGTH(@pcString)) + @pcString)
return @ReturnString
END
______________________________________________________
create function PADR (@pcString varchar(200),@pnLength int,@pcPadChar char(1))
returns varchar(200)
as
BEGIN
declare @ReturnString varchar(200)
if @pcString is NULL
set @pcString = ''
if datalength(@pcString) > @pnLength
set @returnString = left(@pcString,@pnLength)
else
set @ReturnString = (SELECT @pcString + Replicate(@pcPadChar,@pnLength - datalength(@pcString)) )
return @ReturnString
END
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________