View Single Post
  #3  
Old February 9th, 2005, 07:45 PM
mrselfdestruct
external usenet poster
 
Posts: n/a
Default

Thanks, man. That's what I ended up doing. Still, I find that the first and
last functions need some serious reworking. Being that inconsistent just
doesn't make any sense.

"MGFoster" wrote:
Don't use FRIST() or LAST(). In your case use Min(date_column) for the
first date and Max(date_column) for the last date.

--
MGFoster:::mgf00 at earthlink decimal-point net
Oakland, CA (USA)