How can I make this into a single line so I don't have to check for both word occurance orders?
Basically I want to check for the cities in any order and return the state.
WHEN REGEXP_SIMILAR( upper(myColumn),'MIAMI|ORLANDO') = 1
WHEN REGEXP_SIMILAR( upper(myColumn),'ORLANDO|MIAMI') = 1 THEN 'FLORIDA'
end as myState
Solved! Go to Solution.
I don't know why that wouldn't work, although you may have to include both in parentheses for the OR to work: