<div>
It also might be good to mention that if the field is a numeric datatype, you'd have to convert it to a character type or always select it back out adding the zero and converting it to a character:<br />
<br />
SELECT '0' + convert(varchar, ColumnName) from tablename
</div>


It also might be good to mention that if the field is a numeric datatype, you'd have to convert it to a character type or always select it back out adding the zero and converting it to a character:

SELECT '0' + convert(varchar, ColumnName) from tablename

<div>
<div class="content wysiwyg-content">
how do I add a leading 0 to all records in a column of type char?<br />
<br />
exisiting data format &nbsp;= 171347, 171331, etc<br />
required data format = 0171347, 0171331, etc.<br />
<br />
thanks
</div>
</div>


how do I add a leading 0 to all records in a column of type char?

exisiting data format  = 171347, 171331, etc
required data format = 0171347, 0171331, etc.

thanks

Add leading 0's

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.