Hi Chris,
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get distinct rows from a
column with duplicate values and sort it. If there is any misunderstanding,
please feel free to let me know.
As far as I know, there doesn't seem to be a function or an expression for
us to get distinct rows directly from the column. I think we have to go
through each row and get data then compare with existing data to see if it
is duplicated.
However, we can also use some tricks to simplify the compare progress. For
example, we can create a DataTable with a single column. We set a unique
contraint on that column. And then copy data of the original column one by
one to the new column. When duplicate data is copied, an exception will be
thrown. We just swallow that exception and continue. Then we'll get a
column distinct data.
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
