>>>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>
>
>Wrap it in the PROPER(). <g>
Terrific <g> How can I forget about it? <g>
If it's not broken, fix it until it is.
My Blog