SELECT top 200 titles.title_id,titles.category,titles.rating,titles.[year],titles.title,titles.releaseDate as releaseDate3, 'rd'= case when (titles.releaseDate < '1/1/1920' or titles.releaseDate='') then '1/1/'+CAST(year AS varchar(10)) else titles.releaseDate end FROM Titles titles  WHERE title_ID in (select title_id from reviews) and titles.origin like '%%' and (titles.releasedate <= '2/13/2012' )  ORDER BY titles.rd desc, titles.Title; <font face="Arial" size=2>
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial" size=2>error '80040e07'</font>
<p>
<font face="Arial" size=2>[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.</font>
<p>
<font face="Arial" size=2>/search.asp</font><font face="Arial" size=2>, line 241</font>