I need to form a sql 2005 database field into a URL that takes users to a page in an online legislative journal. Let me try to explain: The field in my db is an int field that contains the journal page number. Below is the form script from the public legislative site that takes users to a journal based on the page number provided by the user. The link is to a pdf version of the journal document for the entire day, and although users enter a specific page, the link simply opens the journal for the day that contains that page number.

I guess what I need is a URL field that replicates the output of the form below. Hope this makes sense. Thanks.

<form method=POST action="http://www.senate.leg.state.mn.us/perl/gotopage.pl">
<input type="hidden" NAME="session" value="ls86">
<table id=office border=0>
<tr>
<td valign="top" class=content><b>Enter page number:</b>
<INPUT TYPE="text" NAME="number" SIZE = 6 MAXLENGTH=6>
<INPUT TYPE="submit" VALUE="Go to Page">
<INPUT TYPE="reset" VALUE="Clear Selection"></td>
</tr>
</table>
</form>