I'm used to adding a few fields to a query that don't belong to the table I'm getting data from like (assume table has two fields id int, and name char(30):

select id, name, 0 as completed from mytable

How can I go about a similar select but adding a boolean field to the resulting datatable versus integer?

Select id, name, false as completed from mytable

Doesn't work.

TIA

Terry