View Single Post
  #1  
Old 07-30-2006, 11:54 AM
yogesh yogesh is offline
Junior Member
 
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
yogesh is on a distinguished road
Default select querry question

Hello Folks

If i got a query like this one:

select * from table1 where var1 in (1,2,3,4,.....,100)

is there someway to have something else so that i don't have to put an array from 1 to 100?

thanks a zillion -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - select querry question
View Single Post
  #1  
Old 07-30-2006, 11:54 AM
yogesh yogesh is offline
Junior Member
 
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
yogesh is on a distinguished road
Default select querry question

Hello Folks

If i got a query like this one:

select * from table1 where var1 in (1,2,3,4,.....,100)

is there someway to have something else so that i don't have to put an array from 1 to 100?

thanks a zillion -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote