Two columns, first is distcint, second not so much.

```
Col1 ---- Col2
1    ---- abc
1    ---- abc (123)
2    ---- def
2    ---- def (324)

```

etc

I need to bring back distinct records, but only the ones with the longer Col2. 

I've tried using the CONTAINS function, but my table isn't full-text indexed.