Subject stored procedure, concatenate input parameters
Author Henrik Sitter
Hi, I have a stored procedure with a couple of input parameters that I
want to concatenate:

In_param1 VarChar(100)
In_param2 VarChar(100)
declare variable str VarChar(200)

I was hoping I could do something like:
str = In_param1 & In_param2;

If In_param1 equals "Hello " and In_param2 equals "World", str should
read "Hello World".

This doesn't work. Could anyone help me with this?


[Non-text portions of this message have been removed]