Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I have an existing Data Extension with attributes that contain booleans fields that are marked as false. I want to force those fields and the boolean value to now equal true.
I am wondering if there is a query I can use to update existing subscribers in the Data extension to change them from false to true?
Let's assume the columns name is EmailOptIn
Try this:
Select
True as EmailOptIn
From DataExtensionContainingAttributes
Where
EmailOptIn = False
Update:
As Adam Spriggs suggested, you can also use 1 for true and 0 for false
