Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a boolean field in select
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00843725
Message ID:
00843732
Views:
23
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform