tommym121
asked on
SQL - turn a integer value to a string
If I have a flag has a value (0, 1, 2, 3), I will like to turn into a corresponding label (beginner, basic, intermediate and advanced)
Table 1
Person|SkillLevel
P1 | 0
P2 | 1
P3 | 2
P4 | 3
Like to get the result
P1 | beginner
P2 | basic
P3 | intermediate
P4 | advanced
How do I write such a sql statement
Table 1
Person|SkillLevel
P1 | 0
P2 | 1
P3 | 2
P4 | 3
Like to get the result
P1 | beginner
P2 | basic
P3 | intermediate
P4 | advanced
How do I write such a sql statement
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER