Archives of the TeradataForum
Message Posted: Mon, 05 Jul 2004 @ 16:42:13 GMT
How can I concatenate a string variable in a stored procedure? I want to concatenate a variable in few steps but with the second step I get "Variable too long" error.
Here is an example of a code that I want to use:
DECLARE var1 VARCHAR(20000); set var1 = 'AAA'; set var1 = var1 || 'BBB';
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|