T SQL Select a Constant Value and Concatenate with another Field
Posted on 2016-09-20
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:
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.