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 |
|
saranrosy85@gmail.com
Starting Member
3 Posts |
 Posted - 2008-09-22 : 05:10:02
|
| I want to add some data to the existing data in MsAccess. I tried update tableset empno= empno&'CL' where empno='2100010';update tableset empno= empno||'CL' where empno='2100010';This doesnt work.So plz tel me how to achieve this using Ms.access. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-09-22 : 05:26:21
|
| moved from article discussion._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-09-22 : 05:30:26
|
| <<This doesnt work>>What do you mean?MadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-22 : 06:13:33
|
You forgot the set clauseupdate tableset set empno= (empno+'CL') where empno='2100010' |
|
|
|
|
|
|
how to add some values to an existing data