The problem is that VARCHAR by its very nature can be huge. For that reason they are difficult to work with. My DISTINCT will not work because VarChars cannot be sorted.
Why not test the other three columns (assuming they will uniquely identify the rows)? Dennis McGrath
