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:

True as EmailOptIn
From DataExtensionContainingAttributes
EmailOptIn = False


As Adam Spriggs suggested, you can also use 1 for true and 0 for false

  • You can also use 1 for true and 0 for false. – Adam Spriggs Jul 13 '17 at 11:21
  • Will update my answer – Samuel Dare Jul 16 '17 at 7:18
  • That's good to hear! if it did then community norm is to accept the answer :) – Samuel Dare Aug 1 '17 at 20:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.