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. (
Error converting data type varchar to float when running report · Issue #41 · microsoft/tigertoolbox · GitHub
![sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange](https://i.stack.imgur.com/cgTz5.png)
sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange
![3. What are SQL Data Types and Sizes? VARCHAR, INT, FLOAT, SMALLINT and many more covered in detail. - YouTube 3. What are SQL Data Types and Sizes? VARCHAR, INT, FLOAT, SMALLINT and many more covered in detail. - YouTube](https://i.ytimg.com/vi/lC1ol5x2GNk/sddefault.jpg)
3. What are SQL Data Types and Sizes? VARCHAR, INT, FLOAT, SMALLINT and many more covered in detail. - YouTube
![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)