I have a table in which two of the columns are a number column and the other is a name column as follows:
BranchID
BranchName
1
Specialist - Tax
2
Durban
3
Northam
4
Specialist - Personal Finance
5
PMB
I want to say that wherever part of the word 'Spec' is found it must be aliased as a Specialist Department and if it does not have 'Spec' then it is a branch.
I tried this but when I do a list box on BRANCHTYPE it give me only BRANCH. How do I get this to work?
IF(BranchName = 'Spec*', 'SPECIALIST' , 'BRANCH') AS BRANCHTYPE
