Everything else with SQL and DateTime seems to work so well ... 11:22:28 AM'<BR><BR>Here was my guess for how it should work:<BR>WHERE DATETIME_COLUMN = CONVERT(datetime, '1/20/2004 11:22:28 ...

In order to use UNION, the column list for all the SELECTS must be the same (at least in type/length), since it's returning a single resultset; you're basically trying to return both the email and ...