I intend to write application based on local views which will be upsized to SQL Server or Oracle. Is there any things I should not do that may cause compatbilty problem when I upsize later?

Eg. Can I used function in my SQL such as :

SELECT patient_id,lastvisit(),.... where lastvisit is a UDF.

Regards