<div>
<div class="content wysiwyg-content">
Hi expert,<br />
I need to run a sql scrip to join 2 fields in a new field called customerno. &nbsp;The customerino is a 8-digit field starting with Alphabet ranging from 1 to 3, and is followed by 5 numeric. &nbsp;Any space between Alphabet and numeric should be filled with zero; example below:<br />
&nbsp; &nbsp; customerno F0000567,<br />
&nbsp; &nbsp; customerno FA001234,<br />
&nbsp; &nbsp;customerno :FAS12345<br />
&nbsp; &nbsp;customern0 :F0000004<br />
<br />
I used the following scrip but I could not get the result I want, any pointers?:<br />
<br />
set customerno=left(Prefix,3)+<wbr />right(coun<wbr />ter,5)<br />

</div>
</div>


Hi expert,
I need to run a sql scrip to join 2 fields in a new field called customerno.  The customerino is a 8-digit field starting with Alphabet ranging from 1 to 3, and is followed by 5 numeric.  Any space between Alphabet and numeric should be filled with zero; example below:
    customerno F0000567,
    customerno FA001234,
   customerno :FAS12345
   customern0 :F0000004

I used the following scrip but I could not get the result I want, any pointers?:

set customerno=left(Prefix,3)+right(counter,5)


How to insert zero into space

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.