December 25th, 2008
Concatenate || (attach values), Part 3 of 4
Posted by
admin in
I. ANSI String Scalar Functions
If we have a table: VENDOR_TBL
If you concatenate the STATE and the COUNTRY columns, you get the following results:
SELECT STATE || COUNTRY
FROM VENDOR_TBL;
Normally-defined character values are padded with spaces to the
length of the column definition.
The concatenation of multiple character columns does not add or
eliminate trailing spaces.
If the column is defined as variable (VARCHAR), then the length
is determined by the inserted value which may or may not
include leading or trailing spaces.
Result Table:
                    
