Hi everyone,

Anybody know how to convert CHAR to FLOAT? What is the syntax to do that? Plz help...
Thanks!

declare @t char(2)
set @t='22'
select convert(float,@t)

You can use the CAST or CONVERT function to convert a char to a float.
CAST ( expression AS data_type )
or
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Hi,
Nut if i want to change the data type in VIEW is it possible?
Or i must do it in the table?
When i try to use the CONVERT in view,
SELECT CONVERT ( FLOAT(20), [Min])
FROM wo_view
it just give me the error message -> Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.
Please give me some advice!