I get a problem with this query

SELECT * FROM RG_23CI WHERE BILL_DATE > '03/31/2007'

IN TABLE RG_23CI DATATYPE OF BILL_DATE IS NVARCHAR SO THIS QUERY DON'T SHOW THE RIGHT DATA SO THEN I TRY TO CONVERT THE BILL_DATE IN TO SMALLDATETIME OR DATETIME FORMAT WITH THIS QUERY

SELECT * FROM RG_23CI WHERE CAST(BILL_DATE AS DATETIME) > '03/31/2007'

THIS QUERY GIVES AN ERROR

(4 row(s) affected)

Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type datetime.


So please help me to solve this problem

This will work:
SELECT * FROM RG_23CI WHERE Convert(varchar(10), BILL_DATE, 101) > '03/31/2007'

And so will this:
SELECT * FROM RG_23CI WHERE Convert(datetime, BILL_DATE) > '03/31/2007'


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

There might be something going on... would you please post the results from the following???

SELECT TOP 10 BILL_DATE
FROM RG_23CI


--Jeff Moden

What is your SET DATEFORMAT setting?

Heh... you were saying something about a new breed of Yaks? I'm going to stop asking these rubbers if they need help :D

--Jeff Moden