Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax for boolean fields
Message
 
To
03/10/2006 01:38:37
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01158768
Message ID:
01158770
Views:
23
This message has been marked as the solution to the initial question of the thread.
if its a Bit field ? then 1 is true 0 is false
WHERE Video.Active=1 AND Video.Sale>10
>
>In VFP, when I include a boolean field in a SQL, I can use something like this:
>
>
>...WHERE Video.Active AND Video.Sale>10
>
>
>But, under SQL Server, I cannot use that when accessing a boolean field. What would be the proper syntax?
Fred Besterwitch, MCP

The harder you work. The luckier you get.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform