Thank you very much for the comments. As a newbie UT member I am glad I stepped up to the premium membership.

In trying to construct views to replicate VFP selects I had created I noticed that some commands do not work. For example:
select ITEMS.q_on_reser, ITEMS.BRAND, IIF(ITEMS.q_on_reser > 0,'Z','') AS SORTORDER from items
choked on the IIF statement.

-Is there an equivalent command while using a remote view?
-Is there an area or website to reference SQL commands?
-Also someone mentioned that you can index a remote view. If true then how?