I set up some remote views as shown:

CREATE SQL VIEW order_purchase CONNECTION sql_hcdc_1 SHARE AS SELECT * FROM order_purchase WHERE Order_ID = ?cOrder_ID ORDER BY order_ID

In some time, I would like to selct all order_purchase, what can I do? any wildcard substitute for cOrder_ID?!

Thanks in advance!

Aaron Chu