tsql replace value on select
- by Zelter Ady
I have a column (SERVICE_ID) in my table where I can have only 3 values: 0, 1 and 2. I'd like on select, on displayed result table, to change those value with some english words.
select client, SERVICE_ID
from customers
displays now:
--------------------------
| John | 1
| Mike | 0
| Jordan | 1
| Oren | 2…