I am trying to sum of amount (data type varchar) column but I am getting error
error converting data type varchar to float.
when I checked the data very carefully I found that there is an amount like C000214534. But when I am removing that varchar amount I am not getting error
select sum(CONVERT(float, ft.amount)) FROM filetransaction ft WHERE ft.fileid <>332 this query gives me the result.
is there any way in sql so that it can sum removing varchar? I do not want to update as everyday the data is inserted from the client's end.
How can I sum those data except the data where varchar type.