This topic is locked

SQL Query Question

7/27/2005 3:03:03 PM
ASPRunnerPro General questions
G
gwr477 author

I want to query the ParksInventory field (which is yes/no) to only display the "yes" results. I've tried the "where" statement, but can't seem to get it to work. Anyone got a solution?
Here is the current SQL:
select [PropertyID],

[Property],

[Zip],

[Address],

[YearAcquired],

[Status],

[OwnedAcres],

[UnownedAcres],

[ParkType],

[ParksInventory]

From [dbo].[tblCamp]
Thanks,

Glenn

admin 7/29/2005

Glenn,
try the following query:

select [PropertyID],

[Property],

[Zip],

[Address],

[YearAcquired],

[Status],

[OwnedAcres],

[UnownedAcres],

[ParkType],

[ParksInventory]

From [dbo].[tblCamp]

where ParksInventory=1