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)
>