>I am having a problem when using select statement with an "AS" clause.
>
>For example:
>

>select cdow(datein) as dayin, minutes/60 as totHours from timecard
>

>

select padr(cdow(datein),12) as DayIn, 00.00+Minutes/60 as TotHours from TimeCard

>"Datein" field is of type date (not datetime) and minutes is a numeric field (width is 10) Is there a way to specify field widths, etc., of dayin and totHours? I am getting results like "Wednes" and "8.0000". It seems that the field widths are obtained from the original table values. (I have century set on I am not sure why dayin is getting truncated) I would like results like "Wednesday" and "8.00". (though it would be nice for it to display 8, but I want up to 2 decimal places)
>
>Thanks,
>Chris