create a boolean in SELECT

I need to return a field “Flag” based on the state of two other fields

SELECT flag as (field1=3 and field2=9) from mytable

guess I’m having a senior moment as to why this is not right

yup a senior moment indeed

SELECT (field1=3 and field2=9) as flag

all the right words, wrong sequence :slight_smile: