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-11-27 : 08:50:09
|
| muralee writes "iam trying this ...to find all fields called "email" which are not ending with @something.com and replacing with "@hotmail.com"UPDATE test SET email = email+'@hotmail.com' WHERE test.email NOT LIKE '%@%';iam using ms access. but this qry adds @hotmail.com for all the entries. but i need to add this to fields which are not having the character "@".help me please.SGMuser." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-11-27 : 09:19:12
|
| MS Access uses "*" wildcard instead of "%". So I am guessing something like this should work: UPDATE test SET email = email+'@hotmail.com' WHERE test.email NOT LIKE '*@*'; |
 |
|
|
|
|
|
find replace kinda stuff