Can I use Hyperlinks in a SQL Server CE database?

Is it possible to store a hyperlink in a SQL Server Compact Edition Database?

Specifically, I would like to have the link point to an .jpg file stored in a folder on the computer.

Thanks!The "hyperlink" field type is not supported, by you can store text in a SQL CE database, both the Hyperlink description and the file path (in 2 nvarchar fields)

Can I use a data field returned from my report as part of the URL address?

I am familiar with the navigation hyperlink action of "Jump to URL" but I cant get it to use the data returned in the report as part of the URL address. When I enter the Url into the expression editor: ="http://internal.company.address/sys1/sys2/caseEdit.pl?case="&"Fields!CaseID.Value" it opens an explorer window but it echos the address and tries to use the text 'Fields!CaseID.Value' instead of the data returned in that field.

Can this be done?

="http://internal.company.address/sys1/sys2/caseEdit.pl?case=" & Fields!CaseID.Value

|||Thanks, this answers my question. Seems so simply once I see the answer.