When I using CONVERT function to convert nvarchar to numeric, I getting error message "Error converting data type nvarchar to numeric".
I read help, and figured out that it is because there is charachters inside nvarchar variable.
But is it possible to convert the same variables without errors, but zeros instead? :)