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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-25 : 11:14:44
|
Tom writes "I'm new to SQL and have set up a MS SQL 7 server. The application that uses it created a table for user accounts called dms_user with the following fields:
o_secprovider o_username o_userdesc o_passwd o_email
Most of these fields get populated from the NT domain such that the first column is the Domain name, the second is the login, then the description and the password.
I would like to be able to automatically fill in the e-mail address field from info in the other fields.
eg. The following is automatically created:
o_secprovider o_username o_userdesc o_passwd o_email
OURDOMAIN jdoe John Doe rty43r8r
OURDOMAIN bdog Big Dog i34ugfj4
I would like to fill the o_email field with
jdoe@ourdomain.com and
bdog@ourdomain.com respectively
Is there a statement that I can run that will do this?
Thanks for any help,
Tom Atkinson" |
|
|
|
|
|
SQL Statement to fill in data