edit

Thanks guys,

mickyT's solution is even faster for large data sets (> 500k) 🙂

Many thanks for your anwers.

I tried the two different approaches from dwain.c with my sample table with 100k nvarchar(50) strings. On my machine with Win 8 64, SQL Server 2012,...