Once again thank you for your prompy advise.

What happen if I would like to search for date range query?
Eg. given 2 dates for any records that are between these
2 dates. Could you show me some examples on how to achieve
the results. Excuse me for being a newbie in SQL. Thanks.

>>In SQL 6.5, the DATE data type comes with Date and Time.
>>Hence the storing of date field without a given time, the
>>SQL will set a default time.
>>
>>I just wonder, how could we make a SQL query with only
>>date input by user? Must I hard code the Time to search
>>for any date range queries? Pls advice.
>
>Try the 'LIKE' clause