SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Add %
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shan1430
Yak Posting Veteran

Malaysia
86 Posts

Posted - 04/21/2008 :  20:37:45  Show Profile  Click to see shan1430's MSN Messenger address  Reply with Quote
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 B

Let 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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/21/2008 :  23:26:11  Show Profile  Reply with Quote
Insert into A ( AA ) Select BB + '%' from B
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000