devxlogo

Combining Columns of Different Types

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 andthe StreetName stored separately. I would like to beable to display the StreetNumber (INT) and the StreetName (CHAR) together in one field. This display wouldbe read only. Is there a way to concatenate the two fieldsinto 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.

See also  5 Ways to Improve Customer Experience
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist