Re: Problem with result set from a simple SQL Select

lenny wrote:

> Hi
>
> I'm making the following select in an Oracle 9i database:
>
> select s.cusip, s.udf3, s.udf2 from trade t, security s where t.sec_sid
> = s.sec_sid and s.udf2 != 'CMO' and end_date >= '25-jan-05';

The first problem I see ... which is where I stop is that I highly doubt end_date is set up as a character field.

You want to avoid implicit casting and use TO_DATE in this situation.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)