<div>
basically the solution of ScottPletcher is correct, but just 1 remark:<br />
it will probably return an error if org_unit_id is a numeric datatype<br />
So the correct solution would be : SELECT RIGHT('0000' + convert(varchar(4),org_uni<wbr />t_cd), 4)<br />
<br />

</div>


basically the solution of ScottPletcher is correct, but just 1 remark:
it will probably return an error if org_unit_id is a numeric datatype
So the correct solution would be : SELECT RIGHT('0000' + convert(varchar(4),org_unit_cd), 4)



<div>
Yes, it would return an error if it were INT/NUMERIC, but the original post stated this:<br />
<br />
&quot;In SQLSERVER the ORG_UNIT_CD has a datatype of varchar&quot; 
</div>


Yes, it would return an error if it were INT/NUMERIC, but the original post stated this:

"In SQLSERVER the ORG_UNIT_CD has a datatype of varchar"

<div>
You're right Scott. <br />
in this case, your solution is 100% correct.<br />

</div>


You're right Scott.
in this case, your solution is 100% correct.


<div>
Thanks Guys ! I am giving the points to Scott, your solution worked for me.
</div>


Thanks Guys ! I am giving the points to Scott, your solution worked for me.

<div>
<div class="content wysiwyg-content">
I am porting some Access sql to SQL Server. I am running into problems with code of the format “FORMAT(ORG_UNIT_CD,'0000'<wbr />) as orgunitcd” which is in the Select clause.<br />
<br />
In SQLSERVER the ORG_UNIT_CD has a datatype of varchar and length 4.<br />
<br />
In Access the datatype is Text and FieldSize is 4.<br />
<br />
Can somebody suggest the equivalent for it?<br />
<br />
Thanks,<br />
Square One<br />

</div>
</div>


I am porting some Access sql to SQL Server. I am running into problems with code of the format “FORMAT(ORG_UNIT_CD,'0000') as orgunitcd” which is in the Select clause.

In SQLSERVER the ORG_UNIT_CD has a datatype of varchar and length 4.

In Access the datatype is Text and FieldSize is 4.

Can somebody suggest the equivalent for it?

Thanks,
Square One


Replacing the ACCESS function 'Format' with SQL server equivalent

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.