SQL Query

[pc_porter]

Hello, I am looking for some help with creating an update query.

Hopefully you guys can help.

It is one single table that needs updated.

I have table "Years" where the data is currently

2003 thru 2006
or
1999 thru 2002
or
2005 thru 2008

and so on

I would like it to be IF...

2003 thru 2006 then update it to 2003,2004,2005,2006
1999 thru 2002 then update it to 1999,2000,2001,2002

and so on.

Help please

Thanks

[SDas]

pc porter, need some more information as I really don't understand what it is you want to do.

Do you mean the table YEARS has rows with a column of data like:

2003
2004
2005

or a column that contains the text:

'2003 thru 2006'
'1999 thru 2002'

[MAK]

need sample data.

[Island1]

The solution would be straightforward, depending upon your answers to the above ... we just have to know more about the data ...

Bill