Very Basic Update - SQL Server Forums

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.

All Forums

Other Forums

MS Access

Very Basic Update

Author

Topic

irehman
Starting Member

22 Posts

Posted - 2001-11-29 : 09:43:35

I have very basic Update question,

I have about 500 records in the table and now I would like to add "p." before every record.

Example Before.

Employee Salary
Roger 5000
Kelly 3000
Sam 5500

Example After Update.
Employee Salary
p.Roger 5000
p.Kelly 3000
p.Sam 5500

Thanks in Advance

Edited by - irehman on 11/29/2001 09:45:32

LarsG
Constraint Violating Yak Guru

284 Posts

Posted - 2001-11-29 : 09:45:06

update t set employee = 'p.' & employee

Edited by - LarsG on 11/29/2001 09:45:43

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources