How to: |
CONCAT removes trailing blanks from a string and then concatenates another string to it. The output is returned as variable length alphanumeric.
CONCAT(string1, string2)
where:
Alphanumeric
Is a string whose trailing blanks will be removed.
Alphanumeric
Is a string whose leading and trailing blanks will be preserved.
CONCAT concatenates CITY and STATE.
CONCAT(CITY,STATE)
For Montgomery Alabama, the result is MontgomeryAlabama.
WebFOCUS | |
Feedback |