I have what should be a simple problem but I cannot seem to get the result I need

I am listing a record from a database for editing of which this is a part ...

<form method="post" action="lmadmin1.asp?Actionvar=update">

<label for="Pregroup">Pre-Group No.</label>
  <input id="Pregroup" name="Pregroup" value=" <% =rs("Pregroup") %>" />
   <br />
  <label for="br_no">BR No.</label>
  <input id="br_no" name="br_no" value=" <% =rs("br_no") %>" />
  <br />
  <label for="other_no">LMS No.</label>
  <input id="other_no" name="other_no" value=" <% =rs("other_no") %>" />
  <br />
<form method="post" action="lmadmin1.asp?Actionvar=update">

The database has unfortunatly many Numeric fields with nothing in them
and if an update is attempted it falls over because of a data trype mismatch

What I want to do is check if the field has no entry and if so replace it with a 0

Please Help !

Topshed

Instead of setting recordset values directly to the input boxes
set the values to variables.if the variable is empty or null,set it to zero.

Thanks I will give it a try

Topshed