>Check new ICASE() function
>>here in long syntax
>>SELECT IIF(nday=1,"monday ",IIF(nday=2,"tuesday ",IIF(nday=3,"wednesday",IIF(nday=4,"thursday ",IIF(nday=5,"friday ",IIF(nday=6,"saturday ",IIF(nday=7,"sunday ","no day"))))))) as cday FROM xtable
Properly improved, thanks to Sergey:
SELECT ICASE(nday=1,"monday ",nday=2,"tuesday ",;
nday=3,"wednesday",nday=4,"thursday",nday=5,"friday ",;
nday=6,"saturday",nday=7,"sunday ") as cday FROM xtable