>No. According to the Transact-SQL Reference on page 189 there is a table of the data conversions. When comparing a DateTime to Char is implicit but comparing a smalldatetime to Char is explicit.
>DLC
I don't understand. I ran the following from the QA and it worked ...
create table mike (sdt smalldatetime)
go
insert into mike values ('1/1/1999')
go
-Mike