[Psycho_Bunny]

"SELECT TOP 1 PERCENT FROM tblRelevant WHERE CAST(fldYourPoint AS BOOLEAN()) = TRUE"

0 ROWS RETURNED

[Scythian]

"SELECT TOP 1 PERCENT FROM tblRelevant WHERE CAST(fldYourPoint AS BOOLEAN()) = TRUE"

    SELECT TOP 1 PERCENT
      FROM tblRelevant R
INNER JOIN tblViableCandidates V 
        ON R.CandidateId = v.CandidateID
     WHERE CAST(fldYourPoint AS BOOLEAN()) = TRUE 

most definitely brings back zero