Removing repeated terms - please help...

[almurph]

Hi,

I have a row of soundex words of the form:

soundexA soundexB soundexC soundexD etc

I want to parse the field and remove any repeated terms. Can anyone
help me please? I want to use the most efficient/fastest method
possible as I have a column with several thousand of such rows to go
through etc...
Any suggestions/comments/code-samples/ideas much appreciated...

Thank you,
Al.

 

[jg]

fastest? in terms of coding, sort and compare next in memory assuming you
have enough RAM
failing that, use dictionary ( a lot more overhead)