I'm getting an obscure issue when
when I run this SQL statement
SELECT TOP 1 S_Date from tbl_name order by RowID
I get this error message :
Msg 9807, Level 16, State 0, Line 1
The input character string does not follow style 112, either change the input character string or use a different style.
but it is OK when I leave out the "order by RowID".
Both SQL Statements will return the same first row and the value of S_Date is NULL and is of type date
Any help welcome!!!