i'll probably use case to_char({trandate},'d') when '7' then 1 when '6' then 1 else 0 end