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 |
|
Topaz
Posting Yak Master
199 Posts |
 Posted - 2007-12-14 : 05:39:44
|
| I use this query:SELECT TOP 4000 * FROM wce_contact where website not like ''and expressemail like '%@%'and idstatus like ''and salutation not like '%there%'and task not like '%x%'I know that I can update a field like this...update wce_contactset task = ''where task in ('x')But how would I update a field that matches the above query? If you read my other post, this would eliminate the need for me to select a range of contacts. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
how would i update these contacts?