Re: SQL - finding next date

On 11/04/2007 21:15, Jon Sime wrote:

>> This is probably a very simple one, but I just can't see the answer and
>> it's driving me nuts. I have a table holding details of academic terms,

Many thanks indeed to all who replied - I particularly like Jeff's
solution, and will use that one.

Regards,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------