Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997

Combining Columns of Different Types

Question:
I am doing a select from a table where I want to combine two fields. Specifically, I have the StreetNumber and the StreetName stored separately. I would like to be able to display the StreetNumber (INT) and the StreetName (CHAR) together in one field. This display would be read only. Is there a way to concatenate the two fields into one?

Answer:
You can convert the integer to characters using either the CAST function or other data type conversion function supported by your database. Then use the concatenation operator as follows:

SELECT ConvertedStreetNumber||' '||StreetName from TABLE...
The double bars perform the actual concatenation.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date