I'm a little rusty but how about something like this?

select top 1 with ties

LogsID, len(Location), Location

from [LOGS]

order by len(Location) desc