>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
It still suffers from the same capitalization problem <g>
If it's not broken, fix it until it is.
My Blog