I have a non-unique column in a MySQL table - I have looked hard for a way in SQL to convert the results of a SELECT into a list of unique values. I know how to define a table at CREATE to have UNIQUE columns but this is not what I want to do. For example : If the result of the SELECT is : 1, 3, 3, 4, 2, 6, 8, 9, 4, 2, 3, 6 I would like to return: 1, 2, 3, 4, 6, 8, 9 i.e. only the unique values of the list. any pointers ? if SQL can't do this, can Zope ? (I'm sure Zope can do it, it can do everything :) Darcy -- --------------------------------------------------- Ph: (734) 764 3377 Email: darcyc@engin.umich.edu URL: http://www-personal.engin.umich.edu/~darcyc/ --------------------------------------------------- 'If you're not part of the solution, you're part of the precipitate' ..... Steven Wright