Wouldn't this work?

select PADR(CDOW(naomisDate), 9, " ") as dayOfWeek from blahBlahEtc

>Hi everybody,
>
>I store 1 for Sunday, 2 for Monday, etc. in the table. Is there a simple way to show Sunday, Monday, etc. instead of the number using Select statement?
>
>Thanks in advance.