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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-07-19 : 14:37:13
|
| Nevermind... |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-19 : 14:38:43
|
| Nope, all references are to original versions of the column.But you can do:SET @TEMP = Email = REPLACE(Email, ' ', ''), Username = @TEMPKristen |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-07-19 : 14:41:20
|
| Yes, I know that, but I'd have had to think.Thanks Kristen... |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-07-19 : 14:41:45
|
| I'm going to quit posting now. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-19 : 14:45:29
|
| "Yes, I know that, but I'd have had to think."No sense changing the habits of a lifetime then ... <g>Kristen |
|
|
|
|
|
|
UPDATE, REPLACE and skipping a step.