SELECT CAST(0 AS bit) AS completed, ...
>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
--sb--