lets say I will have to calculate a column differently based on the value of another column.
Would this be possible?
Lets say I have a table like this
country | bank_code
GB | ABBY090222
GB | BARC203253
GB | ANTS090021
DE | 70150000
DE | 12030000
DE | 70011110
Where country = GB bank_code should be calculated as right([bank_code],6).
(It might be possible that there are more countries [at the moment up to 35 countries of a total of 99 countries may need special calculations] besides GB that need special and different calculations per country.)
All not specified countries keep their original value.
In this example: Where country = DE / bank_code = bank_code.