I have a file that I am trying to query with a column that contains formatted number values like
I am trying to get all the rows that have total revenue > 100000. When I run the query below I get an error "error converting nvarchar to int". How can I fix the query below?
INNER JOIN [B.csv] ON [X.csv].[Product Code] = [B.csv].[Product_Code]
([X.csv].[TotalRevenue] > 100000)