I have a table (I only have read only access to the db) where one of the fields stores the classification
I want to be able to only have one of the various number of classifications be returned based on the following hierarchy:
If Client exists in the classification and Consultant and Architect doesn't appear then return 'End User'
If Architect exists in the classification then return 'Architect'
If Client or Architect don't exist return 'Professional'
Eg Classification field
System Classifications\External Organisation - Architect - Consultant\Building Surveyor - Consultant\Project Management
System Classifications\External Organisation - Client - Consultant\Building Surveyor - Consultant\Project Management
System Classifications\External Organisation - Client
Record 1 would return Architect
Record 2 would return Professional
Record 3 would return End User
Is this possible?