Help with complex SQL

Hi all,

Have the following two column in a table:-

Maturity_date Schedule
01-DEC-2002 {01-JAN-2002 10,01-FEB-2002 20,01-JAN-2003 30} A date List of Dates and amounts with comma seperator.

If any of the dates in the Schedule column are greater then the Maturity_date then I want to ignore them ... i.e. 01-JAN-2003 30 in the above example.......

What is the easiest way of achieving this in SQL?

Many thanks in advance. Received on Wed Sep 04 2002 - 13:21:58 CEST