SQL error converting data type varchat to float

[mikefromoke]

Hi @all,

while trying a simple data load  from an sql-tableview i get this error from qv:

anyone an idea how to get rid of this message? i'm really no sql-expert, but there might be  a way to handle the datasets , maybe with a "convert" or something like that..

any sql-experts?

regards

[PrashantSangle]

Hi,

It is query issue.

Is the above query run properly in your sql editor

If your using SQL server db then look convert() and cast() might help you.

Regards,

Prashant