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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
