Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax for boolean fields
Message
 
À
03/10/2006 01:38:37
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01158768
Message ID:
01158770
Vues:
25
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform