>>>>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>
Don't forget PADR(). <g>
--sb--