Prioritizing

UDA
Enthusiast

Prioritizing

Hi

Does any one knows how to create a query that will pick the highest priority of from the list below,
if I have an ID_Number and Passport, the query must pick ID_Number since is the one with the highest priority.
Identity Type ID_Type_Cd Priority
ID_Number 18 1
Passport 15 2
Other 0 3