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 d.award_date > {^2006-11-31} ORDER BY d.bid_no, d.bid_dash'' ) Rowset_1' --SELECT @SQL EXEC (@SQL)Any ideas?