Temple University

SELECT order_id FROM order_t WHERE order_date = [1998-10-21]; If that statement does not work, perhaps you could convert the date value to a character string and select on that… SELECT order_id FROM order_t WHERE CONVERT(char(8), order_date) = ‘10/21/98’; Search for SQL help and try to find out what date delimiter MS SQL uses. ................
................