This select generates an error message "Command contains unrecognized phrase/keyword".
SELECT hip_no, amount, name top 5 FROM stnhorse WHERE amount <> 0 AND SUBSTR(hip_no,1,1) <> "R" ORDER BY hip_no desc This select creates the cursor successfully. SELECT hip_no, amount, name as horse top 5 FROM stnhorse WHERE amount <> 0 AND SUBSTR(hip_no,1,1) <> "R" ORDER BY hip_no desc The only difference is the "name as horse" column designation before the Top 5 condition, why does this make the select run? James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
