SELECT * FROM table1 WHERE field1="01/01/2002 15:32:22" OR
field1="01/01/2002 08:23:00"

Later,
bware

-----Original Message-----
From: Matt Morgan [mailto:mattmorgan@p...]
Sent: Monday, November 18, 2002 5:04 PM
To: professional vb
Subject: [pro_vb] An SQL question for a slow Monday

Hey all -

OK, another SQL question that does not belong here....

If I have a table with a datetime field, and 2 records with the following
values in the field:

01/01/2002 15:32:22
01/01/2002 08:23:00

and I want to get both of the records, is there a way to get them
_without_ using 'between'?

Thanks
Matt