1. I wanted to remove the Default 'Canada' to a blank which worked using
SQL:
Code: Select all
UPDATE Contacts
SET Country=''
WHERE Country='Canada';
2. I want the opposite for two fields MagChoice and PrivChoice from Blank to Text using
Code: Select all
UPDATE Contacts
SET MagChoice='English'
WHERE MagChoice='';
The field are originally empty.
Similar SQL for PrivChoice changing to PrivChoice to 'Yes'.
3. I was able to change all records omitting the WHERE statement, but if MagChoice was 'None' its now 'English'.
And similar PrivChoice was 'No' its now 'Yes'.
I think the WHERE clause doesn't recognize Empty field using '' .
How can I make this work?