Revisions to Can you filter on a Boolean/Checkbox in a Marketing Cloud SQL Query

added 2 characters in body

Source Link

edited May 24, 2017 at 23:57

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = True"True"

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = True

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = "True"

corrected typo

Source Link

edited May 22, 2017 at 21:32

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = 1True

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = 1

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = True

Source Link

created May 22, 2017 at 21:26

Try subbing True for 1 and 0 for False. It should work. In SFMC these work as booleans values.

SELECT 
c.Id 
, c.Email 
, c.FirstName 
, c.LastName 
, c.Checkbox__c 
FROM Contact_Salesforce c 
WHERE c.Checkbox__c = 1

Return to Answer