CONCAT: Concatenating Strings After Removing Trailing Blanks From the First

How to:

CONCAT removes trailing blanks from a string and then concatenates another string to it. The output is returned as variable length alphanumeric.

Syntax: How to Concatenate Strings After Removing Trailing Blanks From the First

CONCAT(string1, string2)

where:

string2

Alphanumeric

Is a string whose trailing blanks will be removed.

string1

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