|
|
EqualSELECT * FROM People WHERE LName='Smith'The SQL Statement above will retrieve ALL fields: SELECT * From the table named People: FROM People With the requirement that the LName is Smith: WHERE LName='Smith' If this is the original table
Your recordset returned would be this:
IF YOU ARE COMPARING TO A NUMBER, LEAVE OUT THE QUOTES!!! SELECT * FROM People WHERE Category=2 The SQL Statement above will retrieve ALL fields: SELECT * From the table named People: FROM People With the requirement that the Category is 2: WHERE Category=2 If this is the original table
Your recordset returned would be this:
| ||||||||||||||||||||||||||||||||||||||||||