My challenge is to insert the email address in the username_usr field if username field is empty.

The first query returns no rows

SELECT username_usr, EMail
FROM CBA
WHERE username_usr IS NULL

This one does return rows

SELECT username_usr, EMail
FROM CBA
WHERE EMAIL IS NOT NULL

This affects no rows yet there are a number of cases where there is an EMAil and username_usr id empty. FIeld types are identical!

UPDATE CBA SET username_usr = EMail
WHERE username_usr IS NULL


Nick

NULL and empty are not the same thing check for username_user=''

Thanks, i'd forgotten

Nick