Re: case statement - strange results

stephen O'D wrote:
>>1. Columns named attr_2 and attr_11.
>>2. Using VARCHAR2 to hold time.
>>
>>
>>My recommendation is that before you kludge this together you:
>>
>>
>>1. Take a basic class in normalization and database design.
>>2. Learn how to use a column of DATE data type.

> 
> 
> In response to Daniel -
> 
> I am fully aware of normalization and using a date to store times.  I
> did state that this is a vendor application that am an attempting to
> product reports on,

I missed that part. Please name the vendor so that others will not purchase their product. There is no excuse for building something this ugly and hopefully others, forwarned, will be able to convince their management to find a better product.

Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)