Hey Guys, I have a problem. I have a 'Cost' field that is set as a varchar in the source data. Even though I have converted the datatype to an integer e.g. (
![sql server - T-SQL :: Error converting data type varchar to numeric when changing 1 to 0.5 - Stack Overflow sql server - T-SQL :: Error converting data type varchar to numeric when changing 1 to 0.5 - Stack Overflow](https://i.stack.imgur.com/dlA1A.png)
sql server - T-SQL :: Error converting data type varchar to numeric when changing 1 to 0.5 - Stack Overflow
Error converting data type varchar to float when running report · Issue #41 · microsoft/tigertoolbox · GitHub
![SQL SERVER - Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator - SQL Authority with Pinal Dave SQL SERVER - Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/402error.jpg)