Is the asp edit page talking to the database? What kind of query is being used to update this...

Is there any way to modify this update query so that if you were to notice an incorrect e-mail address in a record, and you then modified it to the...

I am glad it worked out for you.

As for what the "a" and "b" are for google "table alias name" to get more detailed info.

No, I am using the same table. Its kind of a self-join. Try replacing "TableName" with your table's name and replacing column names with the right column names.

Let me know...

Is this what you are looking for:

UPDATE TableName

SET email=b.email

FROM TableName a

JOIN (SELECT * FROM TableName WHERE email IS NOT NULL) b

ON a.firstname=b.firstname AND a.surname=b.surname AND a.email IS NULL...

Try this:

UPDATE test_table

SET b='p'

FROM

(SELECT uq_column, count(*) cnt

FROM test_table

GROUP BY uq_column

)TMP

JOIN test_table b

ON TMP.uq_column=b.uq_column AND TMP.cnt=b.cnt

UPDATE test_table

SET b='F'

WHERE b'p'

HTH,

Sups