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?

Thx,
Henrik





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