I have a SQL view that I am modifying and attempting to add a new column 1099 Type. The data for this column is actually a 1 or 4. I need change those values to be specific text. IE when someone runs the view and sees 1099 Type, they should see Miscellaneous instead of a 4. I have am a beginner in sql and need some assistance!