TYpe Conversion

[shipra]

Hello

I just write a sql query in ASP. which give error like "error converting datatype varchar to float" caz fields in database is of float type how can i change datatype. please suggest

[iam_clint]

lets see your query.

cast(column as float)