update table set flag = (select case when bit = true then 'Y' else 'N')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)