I have a table with fields and data type like
companycode [nchar(4)] actcode [nchar(12)] vounum [nchar(14)] trnam [decimel (18,6)]
I like to build a query which will bring almost 900 rows
and build query like
select comcod, actcode, vounum,trnam where comcod=3305 and
vounum in ('BC201203000073',
'BC201206000002') ----------Here I would like to put 900 (nine hundred) vounum data and run the query, the
problem is data type. It is time consuming to edit every data by putting ' ' and append coma (,) for every vounum. Is there any way to paste the vounum without putting single quote ' vounum ' and appending a coma (,) for every vounum and successfully run the query.