Hyperlink Query

[KeyserSoze1877]

I have an Access DB.
In it there is a hyperlink field. I want to query the table and display the actual hyperlink address, not the text.

Say, table name is Test, field is Link.

select link from test

That displays the text of the page name like, Foxnews, I want displayed,

http://www.foxnews.com

thats behind it.


Help!

 

[origdman]

Maybe you should get a better name sucker!

 

[PHV]

Something like this ?
SELECT [Link], HyperlinkPart([Link],2) AS Address
FROM Test;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244