<div>
select replicate('0', 5-len(ltrim(rtrim(fieldnam<wbr />e)))) + fieldname<br />
from yourtablename
</div>


select replicate('0', 5-len(ltrim(rtrim(fieldname)))) + fieldname
from yourtablename

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I want to retrieve value from database if the value has lessthan 5 digits i need to append zeros to make 5 charact or digit using storedprocedure in Sql server 2005. <br />
example, if database has value as &quot;12&quot;, my stored procudure should return &quot;00012&quot;.<br />
Basically i need to do something like padding left with '0'.<br />
<br />
Can you please help me on this.<br />
<br />
<br />
<br />
thanks,<br />
Ram.<br />

</div>
</div>


Hi,

I want to retrieve value from database if the value has lessthan 5 digits i need to append zeros to make 5 charact or digit using storedprocedure in Sql server 2005. 
example, if database has value as "12", my stored procudure should return "00012".
Basically i need to do something like padding left with '0'.

Can you please help me on this.



thanks,
Ram.


Get exact number of chars from storedproc

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.