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
.png "Luminary Alumni"){kind=icon}
