Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2001-01-29 : 08:26:19
|
| Maybe i'm being stupid ?I've got 2 variables of varchar(1) in an SP. I want to simply append/concatenate them together and assign them to a variable of varchar(2) and then return that variable for the developer.I populate the two varchar(1) variables in a cursor and then do...Set @FinalUpdate = FirstUpdate + SecondUpdateand at the end do a SELECT @FinalUpdatethe SP just continually runs without stopping.I've tried not concatenating them and just doing SELECT @FirstUpdate, SecondUpdate and this works fine so i know it's something to do with the concatenation i'm trying to do.Any ideas pleasethanksPaul |
|
|
|
|
|
Concatenating 2 variables