At 11:08 AM 26/05/2006, you wrote:

>What on earth are you trying?
>
>select
>cast((cast('now' as TimeStamp) - dtm_stamp) as integer) as NumDays
>from tbl_event
>where .....

You'd only cast the result of the subtraction if you wanted the
result truncated back to whole days.

./hb