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.

devx-admin

Share the Post: