Sometimes numeric data is stored in columns that have character data types. In order to do calculations with this numeric data, you must convert the character columns to numeric. You can use ...

This way I can take impossible-to-sort varchars, and sort them by the converted field instead, making the recordset prettier.<BR><BR>Right now SCNumber might look like the above, '99' implying ...

This is a pain when trying to display the amounts on a VB form and having to reformat .00 to 0.00.<BR>I am thinking of just using null and >0 values instead of allowing a zero value. <BR><BR>So ...