update employees set userid=substring(.
Jason Joines wrote:
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email
address field. I can
IF I understand you correctly, you should be able to do this:
UPDATE employees SET
userid=substring(per_email_address,1,instr(per_email_address,'@')-1);
Chris
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Jason Joines
Sent: Wednesday, November 05, 2003 9:14 AM
To:
gerald_clark wrote:
update employees set userid=substring(.
Jason Joines wrote:
I have a table called employees on a 3.23.48 server. One of it's
fields is an email address (email) and one is the userid. The primary
key is idnumber. I need to populate the userid field from the email