[SQL] Can’t convert nvarchar to decimal and arithmetic overflow

The solution is to use case

isnumeric checks if the cell “Amount” is a number or not. If is is not a number then it will replace the value with 0. You need to make sure you don’t have any problems with ‘ or wrong commas.

Leave a Reply

Your email address will not be published. Required fields are marked *