Recently I had a requirement to search for items with a certain URL in the Hyperlink field.
I noticed that the value being stored in the Hyperlink field is of the format ,. The is an absolute URL.
Using a CAML query that searches for a matching absolute URL returns no result. It turns out that I have to drop the ‘http://serverName’ from my query. So if the URL I wanted to search on was ‘http://myServer/mySite/lists/…’, then I would just search on ‘/mySite/lists/…’ in the CAML, and I would still use the Eq operator.
Here ‘myServer’ is the name of my current SharePoint server. It would be interesting to see what would happen if myServer was a DNS to some other non-SharePoint website.