An error occurred while converting from nvarchar to numeric. nvarcharnumeric

An error occurred while converting from nvarchar to numeric. nvarcharnumeric

When writing an SQL statement, you need to compare the nvarchar column of the (dictionary) table with the numeric column of Table B;

The dictionary data stored in the nvarchar column needs to be filtered by conditions when the table is joined;

As a result, I wrote the table to get table C, and successfully loaded the list;

 

However, an error is returned when I continue to append the condition to Table C.

 

Select * from (select CONVERT (numeric, t2.ItemText) as BZA, t1. * from t1 join dbo. CodeValue t2 on t1.N = t2.ItemValue

Join Codes t3 on t2.CodeID = t3.CodeID and t3.CodeName = 'dictionary data name') aawhere t1.SZ <BZA

This sentence is added after the first join table.

And ISNUMERIC (t2.ItemText)> 0