Jump to content
Sign in to follow this  
ihernandez791079

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

 

IF

 

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

 

 

 

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

 

 

 

 

 

ANY SUGGESTIONS PLEASE!!!

Share this post


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.

Guest
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.

Loading...
Sign in to follow this  

×
×
  • Create New...