Data Type conversion

[jfras]

I'm looking for a way to convert a field retrieved with a query from the original data type present in the table queried to another data type in the table formed by the query. My source table data type is "character" and the resulting table needs to have this field designated as a floating point or double decimal in order for me to build a chart around the data.

Any help would be appreciated. [sig][/sig]

 

[coda]

Waht's wrong with select blabla, CONVERT(float, char_field), blabla ... ?

Of course you'll run into trouble if the char value is not CONVERTable to float.

If that isn't good enough you might want to get the whole thing into a temporary table and take it from there.

/al [sig][/sig]

 

[Lutfal]

try this

select blabla, char_field=CONVERT(float, char_field) from ...