Boolean in a SQL string

[solo7]

This is really simple I know but, I can't get around it.
I'm constructing an SQL string which involves BOOLEAN values. How do I represent the BOOLEAN values in my SQL string ??
I know with text we use the '" & STRINGTEXT & "'
and with dates we use the '# & DATEVALUE & #'

Steady ...

 

[jebry]

Hi!

You don't need anything to go around the value. You should get good results if it comes back True/False, Yes/No or -1/0.

hth
Jeff Bridgham
bridgham@purdue.edu