I keep forgetting how I did this and having to dig into old demo VMs – you can display hyperlinks via calculated columns:
Yup, the AnimalName column is calculated, and consists of a URL and a search term which is the item’s title:
Although it doesn’t show it, [ID] is also a valid column to insert.
Sadly, I’ve not figured out how to display a ‘pretty’ calculated column yet – for example one that just showed ‘Click me‘ rather than the full URL. Still, I thought that having a link to search was interesting. And naturally, if you use the DataView web part then setting up the link with a ‘pretty’ link is trivial.