I have a <b>float type column</b> in a <i>sql database</i> <br>but i am <i>presently storing numeric data</i> in that column<br>I want to take that value and then <i>increase it by one</i><br>in access it worked properly but since it is in sql it does not work <br><br>gives me datatype mismatch<br><br>How in <i>vbscript or asp</i> do you specify that the variable that you are talking the value in do <b>i convert in into numeric format<b> <br><br>so that i can increase it by one <p>Unicorn11<br><a href=mailto:webmaster@tripmedia.com>webmaster@tripmedia.com</a><br><a href= > </a><br>Hi there it all likeminded fellows!!!!!!