an if clause in a sql query

[dee-u]

Since the field is text it's value cannot be converted to true or false, perhaps you would need another field for it.