Cast an entire field from VARCHAR to FLOAT

[Cyprus106]

How do I cast the entire table field from varchar to float?

Granted, I know the risks involved with doing this, but nonetheless...

[Delerna]

Do you mean in the table itself or in a query using the table?

Convert(type,fi eld) is what you use in a query
To change it in the table just design the table and change the type.
I say now more on that as you say you are aware of the danders

[ck9663]

Here's the complete CAST and CONVERT syntax

-- CK