3000
160
50
80
any way to do as follows instantly without manual add
'3000'
'160'
'50'
'80'
sample data script
drop table #Temp
create table #Temp(No int)
insert into #Temp select 3000
insert into #Temp select 160
insert into #Temp select 50
insert into #Temp select 80
select * from #Temp
select
QUOTENAME(No,'''')
from
#Temp
why do you want to do that?
there are more than 100000 values to get in to select Q
Not sure I understand. What will ise this data or are you just learning