select querry question

[yogesh]

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 --

[Visco]

say var > 0 and < 101 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[embury]

There is an other option

Provided if you intend to have all the integers between 1 and 100 :

Code:

where var1 between 1 and 100 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --