I got a column in a table showing 'Work Order Type' (text column).  I need to add a new column to show a different value. 

For example if Work Order Type is 1, value in the new calculated column should show "1 - Reactive WO"

For example if Work Order Type is 2, value in the new calculated column should show "2 - Proactive WO", else shows "".

I thought I could use Switch , but it seems that Switch does not support comparing values of type Text.  What command should I use?