I have  a table x with some data in field  y like

01.01.1997
02.01.1997
01.01.1998

And would like to get a list of all years

1997
1998

I tried "SELECT DISTINCTROW year(y) FROM x"

and get following:

1997
1997
1998

Obviously the DISTINCTROW will not take effect. What shall I do else?

Thanks for your help

Thomas Spiess
http://www.*-*-*.com/

Try

SELECT DISTINCT YEAR(x) FROM x

DISTINCTROW evaluates all the line, if you are not referring to all of
them.

EBR

change distinctrow to distinct.

hth

Ron Regan
Independent Consultant
Boston, MA