Varchar to numeric data type 1

[mattbrenn]

Crystal 10 accessing a SQL2K db.

Hi
I have a quantity field that i would like to perform a sum on, but the data type of the field set in the db is varchar. I'd like to change it to a numeric data type, but am not sure of the best way to do so. Any ideas?

TIA
Matt

 

[kskid]

The following checks for numeric data. Nulls and non-numerics are set to 0

//@fieldn
if isnull({table.field}) or {table.field} = "" then
  0
else if isnumeric({table.field}) then tonumber({table.field})
else 
  0

You can now perform summary totals against @field

-lw