Jump to content

Column combination Query! not addition

Recommended Posts

Anyone have any suggestions.??


I have Table <customers>


I need to query the data points in Column ID ( data type_ Int ) and Column Lot (data type_Int) FROM customers


but what my query is doing is adding this two data points up. and I don't want a SUM result.


ex. if


ID = 100 and Lot = 543 my query result = 643


what I am looking for is




ID=100 and Lot = 543 my query result should be= 100543




SELECT customers.ID + ' ' +customesr.Lot AS combined FROM customers







Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...