<div>
e.g.<br />
To pad a value to 4 digits:<br />
<br />
DECLARE @intNumber INTEGER<br />
SET @intNumber = 1<br />
<br />
SELECT RIGHT('0000' + CAST(@intNumber AS VARCHAR), 4)<br />

</div>


e.g.
To pad a value to 4 digits:

DECLARE @intNumber INTEGER
SET @intNumber = 1

SELECT RIGHT('0000' + CAST(@intNumber AS VARCHAR), 4)


<div>
CREATE FUNCTION PadLeft(@text varchar(1000), @fillchar char(1), @totallength int)<br />
RETURNS varchar(1000)<br />
AS<br />
WHILE LEN(@text) &lt;&nbsp;@totallength<br />
&nbsp; &nbsp; &nbsp;SET @text = @fillchar + @text<br />
RETURN @text<br />
END
</div>


CREATE FUNCTION PadLeft(@text varchar(1000), @fillchar char(1), @totallength int)
RETURNS varchar(1000)
AS
WHILE LEN(@text) < @totallength
     SET @text = @fillchar + @text
RETURN @text
END

<div>
Thanks Rob, that was exactly what I needed. &nbsp;Functional and lightweight.
</div>


Thanks Rob, that was exactly what I needed.  Functional and lightweight.

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
Kind of new at this SQL stuff and I'm needing to pad some values when I run a query. &nbsp;Does anyone know of a good way to pad values in a query via a function or something? &nbsp;Also I need the pad to be with 0's with my data right justified. (0's on the left)<br />
<br />
Thanks,<br />
BBS
</div>
</div>


Hello all,

Kind of new at this SQL stuff and I'm needing to pad some values when I run a query.  Does anyone know of a good way to pad values in a query via a function or something?  Also I need the pad to be with 0's with my data right justified. (0's on the left)

Thanks,
BBS

Padding Function

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.