SQLBill,

You answered my question. Thanks much

Cindy

jpipes,

My actual query has other combinations in the where clause . This stored proc will come in handy another time.Thank You.

The original question was intended to be:-

why does the query...

SQLBill,

The convert function will truncate the time part and give the output in the format 'mm/dd/yy' (for 101).

Then why wouldn't the query

SELECT * FROM tblprojects WHERE insertedDate >= CONVERT(smalldatetime, '01/01/2003',...

SQLBill,

First for some reason I could not find my way to post in T-SQL or programming forums.

The dates are interpreted as 'mm/dd/yy' and not 'dd/mm/yy'.

<= '05/01/2003' will include...