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.