Finding the longest entries for a given column (nvarchar(100))
You can achieve this with this code snippet:

SELECT TOP 1 LEN(column), column
FROM yourTable
ORDER BY LEN(column) DESC


Just replace column with your column which holds the nvarchar(100)