Convert boolean constant to a number

  • Thread starter Thread starter angelo
  • Start date Start date
A

angelo

How can I convert an intrinsic boolean constant (field
name with a boolean field defined as yes/no) to a number
so that I can use the number in an mathematical
expression in a query?

Examples
"true" or "yes" to -1
"false" or "no" to 0 (zero)
 
Back
Top