SQL Example 1:

Pretend you accidentally entered 50 of your contacts' street addresses into the "Address2" Field (on the 2nd tab of the Page Box Control ) instead of the "Address1" Field where the rest of your contacts' addresses are stored.  So, you need to have ContactTalk change "Address1" to be "Address2" on those 50 contacts.

To see the Step by Step instructions for this example, click here.

SQL Example 2:

Let's say you have a large number of contacts who live in the United States, and you want ContactTalk to automatically fill in the "Country1" Field for you on all of those contacts so that you don't have to enter them one by one manually.

To see the Step by Step instructions for this example, click here.

SQL Example 3:

Let's say you had created a Field called "Nickname" to identify several contacts by a different name, other than their actual full name (such as Mom, Dad, Aunt, Grandma, etc...), so that when you schedule a "Happy Birthday" Email Action Item to go out to them on their birthdays, the Tag in the email can be set to "NickName" instead of "FirstName".

But you don't have a nickname for your business clients who you also want to receive the  "Birthday" email.  So you need to have ContactTalk set the "Nickname" Field to equal the "FirstName" Field when the "NickName" Field is blank.

To see the Step by Step instructions for this example, click here.