>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
Thanks <g> Just a note - in English all days of the week always start with the capital letter.
If it's not broken, fix it until it is.
My Blog