When I need to index DATE field I always index it with DTOS().


>You would have to have an index on DTOS on date, not the simple date index then.
>
>>>Wait...there are not 31 days in November! That is why it returns blank.
>>>I retract my question.
>>
>>:o))))
>>I just start to give you another solution when I realize that you ask about 31 Nov :o))))
>>But I'll give it, because I prefer it:
>>

>>DECLARE @SQL AS varchar(500)
>>SET @SQL = 'SELECT * FROM
>>		OPENQUERY(VFP_BID,
>>		''SELECT d.bid_no
>>		,d.bid_dash
>>		,d.status
>>		,d.item
>>		,d.cust_po
>>		,d.award_date
>>		FROM bid_det d
>>		WHERE DTOS(d.award_date) > [20061130]
>>		ORDER BY d.bid_no, d.bid_dash''
>>		) Rowset_1'
>>
>>--SELECT @SQL
>>EXEC (@SQL)
>>