SELECT code AS selId, codeDesc AS selText FROM PropTypeTbl WHERE code NOT IN ('*') ORDER BY selText

country prov city propType