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 |
|
junior6202
Starting Member
45 Posts |
 Posted - 2015-01-07 : 13:33:19
|
| I have a question, what kind of Query or function do I have to use to UPDATE multiple record that I just want to add a letter at the end of the existing OrderNum. Thanks in advance,see example below.BeforeID NAME OrderNum1 Pete WEB1232 Paul WEB1243 Sam WEB1254 Tim WEB126After ID NAME OrderNum1 Pete WEB123A2 Paul WEB124A3 Sam WEB125A4 Tim WEB126A |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-07 : 13:39:41
|
| update yourtable set OrderNum = OrderNum + 'A'Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
junior6202
Starting Member
45 Posts |
Posted - 2015-01-07 : 13:46:51
|
| Thank you so much Tara. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Update Statement
Tara Kizer