Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Re: Changing Data

Status
Not open for further replies.
wsam

wsam

MIS
Apr 27, 2001
19
CA
I have to update employee ids to add one character to the front of them. It would be too time consuming to do each record individually. What would the SQL be?

have 1223 Smith Mary

want Q1223 Smith Mary

Could anyone help? Thanks
 
Sort by date Sort by votes
Update emp_master set Employee_number = 'Q'||Employee_number I tried to remain child-like, all I acheived was childish.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
441
SkipVought
S
Sufi Shahzad
  • Question
Fingr printer reader digital personna 4500
Replies
0
Views
144
Sufi Shahzad
Sufi Shahzad
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
149
TheLazyPig
TheLazyPig
George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
377
carp
carp
Detonah
  • Locked
  • Question
Micros Res 3700 - Cashier Report Displaying Multiple Days Together
Replies
0
Views
313
Detonah
Detonah

Part and Inventory Search

Sponsor

Back
Top