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 |
|
shan1430
Yak Posting Veteran
86 Posts |
 Posted - 2008-04-21 : 20:37:45
|
| Hi, i used the following to insert data from one table to another. How do i add % to the value that i insert?Insert into A ( AA )Select BB from BLet say BB has the value 7,8,9 in the column then AA should have 7%,8%,9% in the column. Please help. Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-21 : 23:26:11
|
| Insert into A ( AA ) Select BB + '%' from B |
 |
|
|
|
|
|
Add %