I have a simple Sql Query as follows:
SELECT product_id, product_desc, product_long_desc
WHERE product_id in (180515,180940,180945,180950,180955,180960,182105,182106.................................)
Running the query produces the following error: Conversion failed when converting the varchar value 180110"" ' to data type int.
Having spent a couple of hours on this I understand that there is some sort of data type mismatch. product_id is char(30), product_desc(nvarchar(100) and product_long_desc is nvarchar(2000). Think I need to add CAST or Convert into query but cannot work out how to do it. Also I dont understand why the query stalls on 180110 as it is not in my list?
Grateful if someone could show me how to solve this problem.