snpcrd
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by snpcrd
-
-
Hi,Having a problem selecting records from an Access 2003 database. With the below SQL from what I understand it should select all records in the database based on using the wildcard character '%'.
SELECT * FROM Unsnooped WHERE RegionCode LIKE '%' AND ClinicGroup LIKE '%' AND Snooped LIKE '%' ORDER BY Sitecode ASC
Example DB records can be found at . The rightmost field is the one called 'Snooped'. There are 1033 records in the DB but it will only display 496. All the fields that I'm trying to pull out are populated by values so I'm a bit of a loss.Cheers
-
Hi,Having a problem selecting records from an Access 2003 database. With the below SQL from what I understand it should select all records in the database based on using the wildcard character '%'.
SELECT * FROM Unsnooped WHERE RegionCode LIKE '%' AND ClinicGroup LIKE '%' AND Snooped LIKE '%' ORDER BY Sitecode ASC
Example DB records can be found at . The rightmost field is the one called 'Snooped'. There are 1033 records in the DB but it will only display 496. All the fields that I'm trying to pull out are populated by values so I'm a bit of a loss.Cheers
Problem with Select and using wildcard characters
in SQL
Posted