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