Invalid operator for data type. Operator equals divide, type equals nvarchar.

i have this problem when i try to import data using cursors function

...dbo.mst.Value/dbo.mst.Quantity as Price

i check the fields Value an Quantity with isnumeric function and the output was 1.

i don't know what to do from now

Can you provide the code so that we can understand your problem correctly.

( CAST(dbo.mst.Value AS FLOAT) / CAST(dbo.mst.Quantity AS FLOAT) ) as Price