Updating A SQL 2005 DB With Info From FreeTextbox

Hi,

I'm writing a very simple content management site as a first web project.

The info is being entered in a FreeTextBox ID'd as FreeTextBox2.  When I use an UPDATE command to update the SQL record it inserts a NULL value into the record.  If I change the variable to simple text it inserts it properly.  For example, this inserts Test into the record:

         UpdateCommand="DECLARE @FreeTextBox2 as varChar(100)
         UPDATE t_content
         SET PageContent = 'Test' WHERE PageID = 1">

But when I run this statement it inserts a NULL:

         UpdateCommand="DECLARE @FreeTextBox2 as varChar(100)

         UPDATE t_content

         SET PageContent = @FreeTextBox2 WHERE PageID = 1">

Could someone please point out where I'm going wrong?  Thx :)