This example is based on Customer table in Northwind Database. We utilized the Case statement for information on Continent in hwich customers are located,
Case statement is easy to understand and maintain.
Select {Customers.Country}
case “germany”,”france” ,”Finland”,”denmark”,”Austria”,”belgium”,
“Italy”,”Poland”,”Norway”,”spain”,”Portugal”,”Sweden”,”Switzerland”,
“UK”:
“Europe”
Case “Argentina”,”Brazil” ,”Mexico”,”Venezuela”:
“South America”
Case “USA”,”Canada” :
“North America”
[...] nested “if statements”, creating this type of complicated formula can be avoided by using Select Case Statement [...]
[...] “if statements”, creating this type of complicated formula can be avoided by using Select Case Statement [...]