You can combine or concantenate columns (fields) in a query or T-SQL script. To provide the correct syntax, we need to know the data types and formats of the fileds or coulmns in the table.
For example, if the data types and formats are as follows...
Field1 - datetime
Field2 - char (mm/dd/yy)
Field3 - char (hh:mm:ss)
then the SQL script could be something like...
WHERE field1 = field2 + ' ' + field3
Or
If field1 = field2 + ' ' + field3
Print 'Match'
Else
Print 'No match'
Other data types and formats may require the use of the CONVERT function.
BTW: If field1 is a timestamp data type as you mentioned, you cannot compare it to dates and times as the timestamp data type doesn't really hold date and time data. It is simply a binary field, guaranteed to be unique. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.