<div>
Paul thanks for the reply, sorry for the confusion. &nbsp;That is correct I do not want commas in the return value. <br />
I would like it to be displayed as 123456555555555 &nbsp;instead of 123,456,555,555,555
</div>


<div>
Try<br />

<pre><code class="code-1 nolinks" id="code-20-41808035-1"><span>SELECT replace((VAL(&quot;123456&quot;)+Customer.CustomerID,',','') FROM Customer</span>
</code></pre>
</div>


<div>
thanks for all the replies. I might not be able to do this as many functions do not work<br />
in the app I am using (get a lot of errors), including with CAST.<br />
when I tried something like this:<br />
SELECT '123456'+convert(text,18,C<wbr />ustomer.Cu<wbr />stomerID) AS concat_value FROM Customer<br />
it will bring return a value without errors but still getting the same results (commas after every 3rd character), String did the same. &nbsp;Using VarChar brings back less values and still has the commas. &nbsp;I think I will close this out. &nbsp;Thanks again.
</div>


<div>
Why using CAST to text? Nobody posted that. text as data type is obsolete in SQL server you what I posted, CAST to VARCHAR(size)...
</div>


<div>
I tried that method, it didn't work. &nbsp; &nbsp;I am not using SSMS. &nbsp; Thanks again.
</div>


<div>
Can you be a bit more specific? Didn't work is not enough, code sample that you ran with error massage would be.
</div>


<div>
Sorry, I just saw that the question had been answered.
</div>


<div>
no worries, thanks for the assistance.
</div>


<div>
<div class="content wysiwyg-content">
I am using a proprietary front end application to connect to a SQL Server database. <br />
I want to pad a field with a constant string, by using the code below it works with one minor issue * see below:<br />
<br />
SELECT (VAL(&quot;123456&quot;)+Customer.Cu<wbr />stomerID FROM Customer<br />
<br />
The return value inserts commas every third character: <br />
123,456,555,555,555,555<br />
<br />
I tried a few different changes to the syntax but still getting the same results. &nbsp; The application I use to connect to the SQL Server Database isn't easy to work with - so it is quite a challenge. &nbsp;Thanks for any info.
</div>
</div>


I am using a proprietary front end application to connect to a SQL Server database. 
I want to pad a field with a constant string, by using the code below it works with one minor issue * see below:

SELECT (VAL("123456")+Customer.CustomerID FROM Customer

The return value inserts commas every third character: 
123,456,555,555,555,555

I tried a few different changes to the syntax but still getting the same results.   The application I use to connect to the SQL Server Database isn't easy to work with - so it is quite a challenge.  Thanks for any info.

T SQL Select a Constant Value and Concatenate with another Field

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.